Table: Northwind.dbo.EmployeeTerritories

Collapse All Expand All

Table Properties

Creation Options

Columns

		Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
		EmployeeID		int	4
		TerritoryID		nvarchar	20

Total: 2 column(s)

Indexes

	Index	Primary	Unique
	PK_EmployeeTerritories

Fulltext Index

Statistics

Check Constraints

Identity Column

Referencing Tables

Referenced Tables

	Table	Primary Key or Unique Constraint	Foreign Key
	Employees	PK_Employees	FK_EmployeeTerritories_Employees
	Territories	PK_Territories	FK_EmployeeTerritories_Territories

Total: 2 table(s)

Objects that depend on EmployeeTerritories

Objects that EmployeeTerritories depends on

	Object Name	Object Type	Dep Level
	Employees	Table	1
	Territories	Table	1
	Region	Table	2

Total 3 object(s)

Column Level Dependencies

	Object Name	Column	Object Type
	Employees	EmployeeID	Table
	Territories	TerritoryID	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].[EmployeeTerritories] (
        [EmployeeID]      int NOT NULL,
        [TerritoryID]     nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[EmployeeTerritories]
    ADD
    CONSTRAINT [PK_EmployeeTerritories]
    PRIMARY KEY
    NONCLUSTERED
    ([EmployeeID], [TerritoryID])
    ON [PRIMARY]
GO
ALTER TABLE [dbo].[EmployeeTerritories]
    ADD CONSTRAINT [FK_EmployeeTerritories_Employees]
    FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[EmployeeTerritories]
    ADD CONSTRAINT [FK_EmployeeTerritories_Territories]
    FOREIGN KEY ([TerritoryID]) REFERENCES [dbo].[Territories] ([TerritoryID])
GO

See also

Buildmasters.com.au