Properties

Owner: dbo 
Creation Date: 08/06/2000 
Located On: PRIMARY 
Data Size KB:
Index Size KB:
Rows:
Description:  

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    CustomerID  nchar  10           
    CustomerTypeID  nchar  20           
Total: 2 column(s)

Indexes

Index Primary Unique Description
  PK_CustomerCustomerDemo       
Total: 1 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.CustomerDemographics  FK_CustomerCustomerDemo  PK_CustomerDemographics 
  dbo.Customers  FK_CustomerCustomerDemo_Customers  PK_Customers 
Total: 2 table(s)

Objects that [dbo].[CustomerCustomerDemo] depends on

Object Name Owner Object Type Dep Level
  CustomerDemographics  dbo  Table 
  Customers  dbo  Table 
Total: 2 object(s)

SQL

CREATE TABLE [CustomerCustomerDemo] (
    [CustomerID] [nchar] (5) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [CustomerTypeID] [nchar] (10) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    CONSTRAINT [PK_CustomerCustomerDemo] PRIMARY KEY  NONCLUSTERED
    (
        [CustomerID],
        [CustomerTypeID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_CustomerCustomerDemo] FOREIGN KEY
    (
        [CustomerTypeID]
    ) REFERENCES [CustomerDemographics] (
        [CustomerTypeID]
    ),
    CONSTRAINT [FK_CustomerCustomerDemo_Customers] FOREIGN KEY
    (
        [CustomerID]
    ) REFERENCES [Customers] (
        [CustomerID]
    )
) ON [PRIMARY]
GO


See Also

List of tables