Buildmasters Legacy Database Documentation

Index: PK_Order_Details on Order Details

CollapseAll image

Collapse image Index Properties

 Name   Value 
 ID  1
 Fill Factor  0
 Size, KB  280
 Unique Index 
 Primary Key Index
 Clustered Index 
 Located On  PRIMARY

Collapse image Index Columns

  Name Sort Direction
OrderID ascending
ProductID ascending

Collapse image Index Statistics Structure and Age

 Name   Value 
Updated 08/25/2008
Average key length 8
Density 0.4323953
Rows in the table 2155
Rows sampled for statistics data 2155
Distribution steps 200

Collapse image Extended Properties

No extended properties defined

Collapse image SQL

ALTER TABLE [dbo].[Order Details]
    ADD
    CONSTRAINT [PK_Order_Details]
    PRIMARY KEY
    ([OrderID], [ProductID])
    ON [PRIMARY]
GO

Collapse image See also

[Order Details]


Buildmasters.com.au




Buildmasters Legacy Database Documentation