Index: PK_Territories on Territories

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
	TerritoryID	ascending

Index Statistics Structure and Age

Extended Properties

SQL

ALTER TABLE [dbo].[Territories]
    ADD
    CONSTRAINT [PK_Territories]
    PRIMARY KEY
    NONCLUSTERED
    ([TerritoryID])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au