dbo.EmployeeTerritories

Field Name	Type and Size	Default	Nullable
EmployeeID	int		NOT NULL
TerritoryID	nvarchar(20)		NOT NULL

Primary key for table 'dbo.EmployeeTerritories'

Primary Key Name	Fields
PK_EmployeeTerritories	EmployeeID, TerritoryID

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

Foreign	Primary
EmployeeTerritories.EmployeeID	Employees.EmployeeID
EmployeeTerritories.TerritoryID	Territories.TerritoryID

Indexes for table 'dbo.EmployeeTerritories', 2 items

Index Name	Clustered	Unique	Fields
PK_EmployeeTerritories	No	Yes	EmployeeID, TerritoryID