dbo.Orders

Field Name	Type and Size	Default	Nullable
OrderID	int identity		NOT NULL
CustomerID	nchar(5)		NULL
EmployeeID	int		NULL
OrderDate	datetime		NULL
RequiredDate	datetime		NULL
ShippedDate	datetime		NULL
ShipVia	int		NULL
Freight	money(19.4)	(0)	NULL
ShipName	nvarchar(40)		NULL
ShipAddress	nvarchar(60)		NULL
ShipCity	nvarchar(15)		NULL
ShipRegion	nvarchar(15)		NULL
ShipPostalCode	nvarchar(10)		NULL
ShipCountry	nvarchar(15)		NULL

Primary key for table 'dbo.Orders'

Primary Key Name	Fields
PK_Orders	OrderID

Foreign keys for table 'dbo.Orders', 3 items

Foreign	Primary
Orders.CustomerID	Customers.CustomerID
Orders.EmployeeID	Employees.EmployeeID
Orders.ShipVia	Shippers.ShipperID

Indexes for table 'dbo.Orders', 9 items

Index Name	Clustered	Unique	Fields
PK_Orders	Yes	Yes	OrderID
CustomerID	No	No	CustomerID
CustomersOrders	No	No	CustomerID
EmployeeID	No	No	EmployeeID
EmployeesOrders	No	No	EmployeeID
OrderDate	No	No	OrderDate
ShipPostalCode	No	No	ShipPostalCode
ShippedDate	No	No	ShippedDate
ShippersOrders	No	No	ShipVia

Dependencies for table 'dbo.Orders', 13 items

Object Name	Type
dbo.CustOrderHist	stored procedure
dbo.CustOrdersOrders	stored procedure
dbo.Employee Sales by Country	stored procedure
dbo.Invoices	view
dbo.Orders Qry	view
dbo.Product Sales for 1997	view
dbo.Quarterly Orders	view
dbo.Sales Totals by Amount	view
dbo.Sales by Category	view
dbo.Sales by Year	stored procedure
dbo.SalesByCategory	stored procedure
dbo.Summary of Sales by Quarter	view
dbo.Summary of Sales by Year	view