Transact-SQL Reference

Order Details

Column_name Data type Nullable Default Check Key/index
OrderID int no Composite PK, clust1, FK
Orders(OrderID)2
ProductID int no Composite PK, clust1, FK
Products(ProductID)3
UnitPrice money no 0 yes4
Quantity smallint no 1 yes5
Discount real no 0

1  The composite, primary key, clustered index is defined on OrderID and ProductID.
2  There are also two nonclustered indexes on OrderID.
3  There are also two  nonclustered indexes on ProductID.
4  The UnitPrice CHECK constraint is defined as (UnitPrice >= 0).
5  The Quantity CHECK constraint is defined as (Quantity > 0).
The table-level CHECK constraint is defined as (Discount >= 0 and Discount < = 1).