Index: PK_EmployeeTerritories on EmployeeTerritories

Collapse All Expand All

Index Properties

Name	Value
ID	2
Fill Factor	0
Size, KB	16
Unique Index
Primary Key Index
Clustered Index
Located On	PRIMARY

Index Columns

	Name	Sort Direction
	EmployeeID	ascending
	TerritoryID	ascending

Index Statistics Structure and Age

Extended Properties

SQL

ALTER TABLE [dbo].[EmployeeTerritories]
    ADD
    CONSTRAINT [PK_EmployeeTerritories]
    PRIMARY KEY
    NONCLUSTERED
    ([EmployeeID], [TerritoryID])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au