DATABASE NORTHWIND

TABLES

Categories
CustomerCustomerDemo
CustomerDemographics
Customers
Employees
EmployeeTerritories
Order Details
Orders
Products
Region
Shippers
Suppliers
Territories

VIEWS

Alphabetical list of products
Category Sales for 1997
Current Product List
Customer and Suppliers by City
Invoices
Order Details Extended
Order Subtotals
Orders Qry
Product Sales for 1997
Products Above Average Price
Products by Category
Quarterly Orders
Sales by Category
Sales Totals by Amount
Summary of Sales by Quarter
Summary of Sales by Year

STORED PROCEDURES

CustOrderHist
CustOrdersDetail
CustOrdersOrders
Employee Sales by Country
Sales by Year
SalesByCategory
Ten Most Expensive Products

FUNCTIONS

No functions were found.

TRIGGERS

No triggers were found.

INDEXES

CategoryName
PK_Categories
PK_CustomerCustomerDemo
PK_CustomerDemographics
City
CompanyName
PK_Customers
PostalCode
Region
LastName
PK_Employees
PostalCode
PK_EmployeeTerritories
OrderID
OrdersOrder_Details
PK_Order_Details
ProductID
ProductsOrder_Details
CustomerID
CustomersOrders
EmployeeID
EmployeesOrders
OrderDate
PK_Orders
ShippedDate
ShippersOrders
ShipPostalCode
CategoriesProducts
CategoryID
PK_Products
ProductName
SupplierID
SuppliersProducts
PK_Region
PK_Shippers
CompanyName
PK_Suppliers
PostalCode
PK_Territories

FULL-TEXT CATALOGS

Northwind_Catalog