AdventureWorks

Basic Index   Expanded Index

Table Name:Production.UnitMeasure
Description:Unit of measure lookup table.
Primary Keys:UnitMeasureCode
FieldTypeDefaultsNulls?Comments
UnitMeasureCodenchar (3)NoneNoPrimary key.
Namenvarchar (50)NoneNoUnit of measure description.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_UnitMeasure_UnitMeasureCodeYesYesUnitMeasureCode
AK_UnitMeasure_NameNoYesName

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_BillOfMaterials_UnitMeasure_UnitMeasureCodeProduction.BillOfMaterialsUnitMeasureCode
FK_Product_UnitMeasure_SizeUnitMeasureCodeProduction.ProductSizeUnitMeasureCode
FK_Product_UnitMeasure_WeightUnitMeasureCodeProduction.ProductWeightUnitMeasureCode
FK_ProductVendor_UnitMeasure_UnitMeasureCodePurchasing.ProductVendorUnitMeasureCode

No triggers