Properties

Clustered Index:
Primary Key Index:
Unique Index:
Ignore Duplicates:
Pad Index:
Allow Row Locks:
Allow Page Locks:
Is computed column in index:
Located On:	PRIMARY
Size KB:	16
Fill Factor:	0
Don't Recompute Statistics:
Description:

Index Columns

	Name	Descending
	EmployeeID	0
	TerritoryID	0

Total: 2 column(s)

Statistics

Updated:	Oct 21 2006 5:45PM
Average key length:	14
Density:	0
Rows in the table:	49
Rows sampled for statistics data:	49
Distribution steps:	9

SQL

CREATE  UNIQUE  INDEX [PK_EmployeeTerritories] ON [dbo].[EmployeeTerritories]([EmployeeID], [TerritoryID]) ON [PRIMARY]
GO

See Also

List of indexes