Production.ProductDescription

Table: 'Production.ProductDescription'

4 fields. 836 bytes.

Product descriptions in several languages.

Field Name Data Type Size Original Type Default Nullable Description Check

ProductDescriptionID int identity int Not null Primary key for ProductDescription records.

Description nvarchar 400 Not null Description of the product.

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description
ProductDescriptionID	int identity		int		Not null	Primary key for ProductDescription records.
Description	nvarchar	400			Not null	Description of the product.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductDescription'

Primary Key Name Field Name

PK_ProductDescription_ProductDescriptionID ProductDescriptionID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_ProductDescription_ProductDescriptionID	ProductDescriptionID

Indexes for table 'Production.ProductDescription', 2 items

Index Name Description Clustered Unique Fields

PK_ProductDescription_ProductDescriptionID Clustered index created by a primary key constraint. Yes Yes ProductDescriptionID

AK_ProductDescription_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_ProductDescription_ProductDescriptionID	Clustered index created by a primary key constraint.	Yes	Yes	ProductDescriptionID
AK_ProductDescription_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Production.ProductDescription', 1 item

Name Description Type Enabled

uProductDescription AFTER UPDATE trigger setting the ModifiedDate column in the ProductDescription table to the current date. after Update Yes

Name	Description	Type	Enabled
uProductDescription	AFTER UPDATE trigger setting the ModifiedDate column in the ProductDescription table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductDescription', 2 items

Object Name Type Field Name

Production.uProductDescription trigger N/A

Production.vProductAndDescription view N/A

Object Name	Type	Field Name
Production.uProductDescription	trigger	N/A
Production.vProductAndDescription	view	N/A