Transact-SQL Reference

CustomerCustomerDemo

Column_name Data type Nullable Default Check Key/index
CustomerID nchar(5) no Composite PK nonclust1,
FK Customers(CustomerID)
CustomerTypeID nchar(10) no Composite PK nonclust1,
FK CustomerDemographics(CustomerTypeID)

1  The composite primary key is defined on CustomerID, CustomerTypeID.