Northwind

Basic Index   Expanded Index

Table Name:CustomerDemographics
Primary Keys:CustomerTypeID
FieldTypeDefaultsNulls?
CustomerTypeIDnchar (10)NoneNo
CustomerDescntextNoneYes

IndexClustered?Unique?Fields
PK_CustomerDemographicsNoNoCustomerTypeID

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_CustomerCustomerDemoCustomerCustomerDemoCustomerTypeID

No triggers