AdventureWorks
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used40.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeySalesOrderIDPrimary key. Foreign key to SalesOrderHeader.SalesOrderID.Ascending
Primary KeySalesOrderDetailIDPrimary key. One incremental unique number per product sold.Ascending
Index Statistics
Average key length8.00
Density0.27
Rows in the Table121317
Rows Sampled121317
Distribution Steps146
UpdatedJan 8 2010 8:41AM
See Also

Related Objects

Sales.SalesOrderDetail Table
Sales Schema
AdventureWorks Database

 

 


© 2012 All Rights Reserved.

Send comments on this topic.