AdventureWorks
PK_Location_LocationID Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used8.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyLocationIDPrimary key for Location records.Ascending
Index Statistics
Average key length2.00
Density1.00
Rows in the Table14
Rows Sampled14
Distribution Steps8
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

Production.Location Table
Production Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.