AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductCategory
Description:High-level product categorization.
Primary Keys:ProductCategoryID
FieldTypeDefaultsNulls?Comments
ProductCategoryIDint - IdentityNoneNoPrimary key for ProductCategory records.
Namenvarchar (50)NoneNoCategory description.
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_ProductCategory_ProductCategoryIDYesYesProductCategoryID
AK_ProductCategory_NameNoYesName
AK_ProductCategory_rowguidNoYesrowguid

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ProductSubcategory_ProductCategory_ProductCategoryIDProduction.ProductSubcategoryProductCategoryID

No triggers