Production.ProductDescription

Table: 'Production.ProductDescription'

4 fields. 836 bytes.

Product descriptions in several languages.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductDescriptionIDint identity int Not nullPrimary key for ProductDescription records. 
Descriptionnvarchar400  Not nullDescription of the product. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductDescription'

Primary Key NameField Name
PK_ProductDescription_ProductDescriptionIDProductDescriptionID
There are no Foreign Keys for this table.

Indexes for table 'Production.ProductDescription', 2 items

Index NameDescriptionClusteredUniqueFields
PK_ProductDescription_ProductDescriptionIDClustered index created by a primary key constraint.YesYesProductDescriptionID
AK_ProductDescription_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Production.ProductDescription', 1 item

NameDescriptionTypeEnabled
uProductDescriptionAFTER 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 NameTypeField Name
Production.uProductDescriptiontriggerN/A
Production.vProductAndDescriptionviewN/A