Properties

Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 144 
Index Size KB: 56 
Rows: 762 
Description: Product descriptions in several languages. 

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    ProductDescriptionID  int          Primary key for ProductDescription records. 
    Description  nvarchar  400          Description of the product. 
    rowguid  uniqueidentifier  16    (newid())      ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)

Identity column

Name Seed Increment Not for replication
  ProductDescriptionID   

Indexes

Index Primary Unique Description
  PK_ProductDescription_ProductDescriptionID      Primary key (clustered) constraint 
  AK_ProductDescription_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.ProductModelProductDescriptionCulture  FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID  PK_ProductDescription_ProductDescriptionID 
Total: 1 table(s)

Objects that depend on [Production].[ProductDescription]

Object Name Owner Object Type Dep Level
  ProductModelProductDescriptionCulture  Production  Table 
  vProductAndDescription  Production  View 
Total: 2 object(s)

SQL

CREATE TABLE [ProductDescription] (
    [ProductDescriptionID] [int] IDENTITY (1, 1) NOT NULL ,
    [Description] [nvarchar] (400) COLLATE Latin1_General_CS_AS NOT NULL ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ProductDescription_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductDescription_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ProductDescription_ProductDescriptionID] PRIMARY KEY  CLUSTERED
    (
        [ProductDescriptionID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO


See Also

List of tables