Table: Northwind.dbo.CustomerCustomerDemo

Collapse All Expand All

Table Properties

Creation Options

Columns

		Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
		CustomerID		nchar	5
		CustomerTypeID		nchar	10

Total: 2 column(s)

Indexes

	Index	Primary	Unique
	PK_CustomerCustomerDemo

Fulltext Index

Statistics

Check Constraints

Identity Column

Referencing Tables

Referenced Tables

	Table	Primary Key or Unique Constraint	Foreign Key
	CustomerDemographics	PK_CustomerDemographics	FK_CustomerCustomerDemo
	Customers	PK_Customers	FK_CustomerCustomerDemo_Customers

Total: 2 table(s)

Objects that depend on CustomerCustomerDemo

Objects that CustomerCustomerDemo depends on

	Object Name	Object Type	Dep Level
	CustomerDemographics	Table	1
	Customers	Table	1

Total 2 object(s)

Column Level Dependencies

	Object Name	Column	Object Type
	CustomerDemographics	CustomerTypeID	Table
	Customers	CustomerID	Table

Total 2 column(s)

Graphical Dependencies

Extended Properties

Permissions

Table Options

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CustomerCustomerDemo] (
        [CustomerID]         nchar(5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [CustomerTypeID]     nchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[CustomerCustomerDemo]
    ADD
    CONSTRAINT [PK_CustomerCustomerDemo]
    PRIMARY KEY
    NONCLUSTERED
    ([CustomerID], [CustomerTypeID])
    ON [PRIMARY]
GO
ALTER TABLE [dbo].[CustomerCustomerDemo]
    ADD CONSTRAINT [FK_CustomerCustomerDemo]
    FOREIGN KEY ([CustomerTypeID]) REFERENCES [dbo].[CustomerDemographics] ([CustomerTypeID])
GO
ALTER TABLE [dbo].[CustomerCustomerDemo]
    ADD CONSTRAINT [FK_CustomerCustomerDemo_Customers]
    FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([CustomerID])
GO

See also

Buildmasters.com.au