Database : Northwind
		Report created by EasyStruct 4.5 on 8/16/2004

Tables

Views

Stored Procedures

Indexes

Tables

Orders Top Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description  OrderID 1 No int 10 CustomerID 2 YES nchar 5 EmployeeID 3 YES int 10 OrderDate 4 YES datetime 23 RequiredDate 5 YES datetime 23 ShippedDate 6 YES datetime 23 ShipVia 7 YES int 10 Freight 8 (0) YES money 19 ShipName 9 YES nvarchar 40 ShipAddress 10 YES nvarchar 60 ShipCity 11 YES nvarchar 15 ShipRegion 12 YES nvarchar 15 ShipPostalCode 13 YES nvarchar 10 ShipCountry 14 YES nvarchar 15 Orders Top Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column FK_Orders_Customers Customers Orders CustomerID NO ACTION NO ACTION CustomerID FK_Orders_Employees Employees Orders EmployeeID NO ACTION NO ACTION EmployeeID FK_Orders_Shippers Shippers Orders ShipVia NO ACTION NO ACTION ShipperID PK_Orders Top Name PK_Orders Table Name Orders Index Type Clustered Unique False Index FillFactor 0 Primary Key True Ignore Duplicate Row False PK_Orders - Columns Top Column Name Sort Order OrderID Ascending Tables Views Stored Procedures Indexes CustomerID Top Name CustomerID Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False CustomerID - Columns Top Column Name Sort Order CustomerID Ascending Tables Views Stored Procedures Indexes CustomersOrders Top Name CustomersOrders Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False CustomersOrders - Columns Top Column Name Sort Order CustomerID Ascending Tables Views Stored Procedures Indexes EmployeeID Top Name EmployeeID Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False EmployeeID - Columns Top Column Name Sort Order EmployeeID Ascending Tables Views Stored Procedures Indexes EmployeesOrders Top Name EmployeesOrders Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False EmployeesOrders - Columns Top Column Name Sort Order EmployeeID Ascending Tables Views Stored Procedures Indexes OrderDate Top Name OrderDate Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False OrderDate - Columns Top Column Name Sort Order OrderDate Ascending Tables Views Stored Procedures Indexes ShippedDate Top Name ShippedDate Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False ShippedDate - Columns Top Column Name Sort Order ShippedDate Ascending Tables Views Stored Procedures Indexes ShippersOrders Top Name ShippersOrders Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False ShippersOrders - Columns Top Column Name Sort Order ShipVia Ascending Tables Views Stored Procedures Indexes ShipPostalCode Top Name ShipPostalCode Table Name Orders Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False ShipPostalCode - Columns Top Column Name Sort Order ShipPostalCode Ascending Tables Views Stored Procedures Indexes Products Top Column Name Ordinal Position Default Value Null Allowed Data Type Precision <