Northwind

Basic Index   Expanded Index

Table Name:CustomerCustomerDemo
Primary Keys:CustomerID
CustomerTypeID
FieldTypeDefaultsNulls?
CustomerIDnchar (5)NoneNo
CustomerTypeIDnchar (10)NoneNo

IndexClustered?Unique?Fields
PK_CustomerCustomerDemoNoNoCustomerID
CustomerTypeID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_CustomerCustomerDemoCustomerTypeIDCustomerDemographics
FK_CustomerCustomerDemo_CustomersCustomerIDCustomers

No primary keys as foreign key constraints
No triggers