Production.Illustration Table

Information

NameIllustration
SchemaProduction
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
IllustrationTABLEMS_DescriptionBicycle assembly diagrams.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   IllustrationIDint   
 
 
 
   Diagramxml   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_Illustration_IllustrationIDClustered  IllustrationID

SQL Script

CREATE TABLE [Production].[Illustration] (
    [IllustrationID] int NOT NULL IDENTITY,
    [Diagram] xml NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);