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: 80 
Fill Factor:
Don't Recompute Statistics:  
Description:  

Index Columns

Name Descending
  CustomerID 
Total: 1 column(s)

Statistics

Updated: Oct 21 2006 5:45PM  
Average key length: 10 
Density: 1.098901E-02 
Rows in the table: 91 
Rows sampled for statistics data: 91 
Distribution steps: 91 

SQL

CREATE  UNIQUE  CLUSTERED  INDEX [PK_Customers] ON [dbo].[Customers]([CustomerID]) ON [PRIMARY]
GO

See Also

List of indexes