dbo.CustomerCustomerDemo

Field Name	Type and Size	Default	Nullable
CustomerID	nchar(5)		NOT NULL
CustomerTypeID	nchar(10)		NOT NULL

Primary key for table 'dbo.CustomerCustomerDemo'

Primary Key Name	Fields
PK_CustomerCustomerDemo	CustomerID, CustomerTypeID

Foreign keys for table 'dbo.CustomerCustomerDemo', 2 items

Foreign	Primary
CustomerCustomerDemo.CustomerTypeID	CustomerDemographics.CustomerTypeID
CustomerCustomerDemo.CustomerID	Customers.CustomerID

Indexes for table 'dbo.CustomerCustomerDemo', 2 items

Index Name	Clustered	Unique	Fields
PK_CustomerCustomerDemo	No	Yes	CustomerID, CustomerTypeID