Owner: | dbo |
Creation Date: | 08/06/2000 |
Located On: | PRIMARY |
Data Size KB: | 0 |
Index Size KB: | 0 |
Rows: | 0 |
Description: |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
|
|
CustomerID | nchar | 10 |
|
|
|
||
|
|
CustomerTypeID | nchar | 20 |
|
|
|
Index | Primary | Unique | Description | |
|
PK_CustomerCustomerDemo |
|
|
Table | Foreign Key | Primary Key or Unique Constraint | |
|
dbo.CustomerDemographics | FK_CustomerCustomerDemo | PK_CustomerDemographics |
|
dbo.Customers | FK_CustomerCustomerDemo_Customers | PK_Customers |
Objects that [dbo].[CustomerCustomerDemo] depends on
Object Name | Owner | Object Type | Dep Level | |
|
CustomerDemographics | dbo | Table | 1 |
|
Customers | dbo | Table | 1 |
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