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	4					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	8		(getdate())			Date and time the record was last updated.

Total: 4 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	ProductDescriptionID	1	1

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	1
	vProductAndDescription	Production	View	2

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