Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Orders

SQL Server 2000
Column_name Data type Nullable Default Check Key/index
OrderID int no IDENTITY (1,1) PK, clust.
CustomerID nchar(5) yes FK Customers(CustomerID)1
EmployeeID int yes FK Employees(EmployeeID)2
OrderDate datetime yes GETDATE () Nonclust.
RequiredDate datetime yes
ShippedDate datetime yes Nonclust.
ShipVia int yes   FK Shippers(ShipperID)3
Freight money yes 0
ShipName nvarchar(40) yes
ShipAddress nvarchar(60) yes  
ShipCity nvarchar(15) yes
ShipRegion nvarchar(15) yes  
ShipPostalCode nvarchar(10) yes Nonclust.
ShipCountry nvarchar(15) yes

1  There are also two nonclustered indexes on CustomerID.
2  There are also two nonclustered indexes on EmployeeID.
3  There is also a nonclustered index on ShipVia.

Show:
© 2015 Microsoft