AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductSubcategory
Description:Product subcategories. See ProductCategory table.
Primary Keys:ProductSubcategoryID
FieldTypeDefaultsNulls?Comments
ProductSubcategoryIDint - IdentityNoneNoPrimary key for ProductSubcategory records.
ProductCategoryIDintNoneNoProduct category identification number. Foreign key to ProductCategory.ProductCategoryID.
Namenvarchar (50)NoneNoSubcategory 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_ProductSubcategory_ProductSubcategoryIDYesYesProductSubcategoryID
AK_ProductSubcategory_NameNoYesName
AK_ProductSubcategory_rowguidNoYesrowguid

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_ProductSubcategory_ProductCategory_ProductCategoryIDProductCategoryIDProduction.ProductCategory

Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_Product_ProductSubcategory_ProductSubcategoryIDProduction.ProductProductSubcategoryID

No triggers