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: 120 
Fill Factor:
Don't Recompute Statistics:  
Description: Primary key (clustered) constraint 

Index Columns

Name Descending Included
  EmployeeID     
Total: 1 column(s)

Statistics

Updated: Apr 26 2006 11:49AM 
Average key length:
Density:
Rows in the table: 290 
Rows sampled for statistics data: 290 
Distribution steps: 146 

SQL

CREATE  UNIQUE  CLUSTERED  INDEX [PK_Employee_EmployeeID] ON [HumanResources].[Employee]([EmployeeID]) ON [PRIMARY]
GO

See Also

List of indexes