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.