Production.ProductDescription Table

Information

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

Extended Properties

NameTypeProperty NameValue
ProductDescriptionTABLEMS_DescriptionProduct descriptions in several languages.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   ProductDescriptionIDint   
 
 
 
   Descriptionnvarchar(400) SQL_Latin1_General_CP1_CI_AS 
 
 
 
   rowguiduniqueidentifier   
(newid())
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_ProductDescription_ProductDescriptionIDClustered  ProductDescriptionID
AK_ProductDescription_rowguidNonClustered  rowguid

SQL Script

CREATE TABLE [Production].[ProductDescription] (
    [ProductDescriptionID] int NOT NULL IDENTITY,
    [Description] nvarchar(400) NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_ProductDescription_rowguid] on [Production].[ProductDescription]([rowguid]);