AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductDescription
Description:Product descriptions in several languages.
Primary Keys:ProductDescriptionID
FieldTypeDefaultsNulls?Comments
ProductDescriptionIDint - IdentityNoneNoPrimary key for ProductDescription records.
Descriptionnvarchar (400)NoneNoDescription of the product.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_ProductDescription_ProductDescriptionIDYesYesProductDescriptionID
AK_ProductDescription_rowguidNoYesrowguid

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionIDProduction.ProductModelProductDescriptionCultureProductDescriptionID

No triggers