AdventureWorks

Basic Index   Expanded Index

Table Name:Production.ProductModel
Description:Product model classification.
Primary Keys:ProductModelID
FieldTypeDefaultsNulls?Comments
ProductModelIDint - IdentityNoneNoPrimary key for ProductModel records.
Namenvarchar (50)NoneNoProduct model description.
CatalogDescriptionxmlNoneYesDetailed product catalog information in xml format.
InstructionsxmlNoneYesManufacturing instructions in xml format.
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_ProductModel_ProductModelIDYesYesProductModelID
AK_ProductModel_NameNoYesName
AK_ProductModel_rowguidNoYesrowguid

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_Product_ProductModel_ProductModelIDProduction.ProductProductModelID
FK_ProductModelIllustration_ProductModel_ProductModelIDProduction.ProductModelIllustrationProductModelID
FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelIDProduction.ProductModelProductDescriptionCultureProductModelID

No triggers