Northwind Database (Document! X Sample)
PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID Index
AdventureWorks Database > Purchasing Schema > Purchasing.PurchaseOrderDetail Table : PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID Index
Description
Primary key (clustered) constraint
Properties
File GroupPRIMARY
Space Used16.00 KB
Fill Factor0
Do not Recompute Statistics
Full Text Key
Clustered Index
Primary Key Index
Unique Index
Pad Index
Columns
 ColumnDescriptionSort Order
Primary KeyPrimary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID.Ascending
Primary KeyPrimary key. One line number per purchased product.Ascending
Index Statistics
Average key length8.00
Density0.50
Rows in the Table8845
Rows Sampled8845
Distribution Steps185
UpdatedOct 27 2017 2:33PM
See Also

Related Objects

Purchasing.PurchaseOrderDetail Table
Purchasing Schema
AdventureWorks Database