Table of Contents
Database: Northwind
Tables
dbo.Categories
Indexes
PK_Categories
CategoryName
dbo.CustomerCustomerDemo
Indexes
PK_CustomerCustomerDemo
Relationships
FK_CustomerCustomerDemo
FK_CustomerCustomerDemo_Customers
dbo.CustomerDemographics
Indexes
PK_CustomerDemographics
dbo.Customers
Indexes
PK_Customers
City
CompanyName
PostalCode
Region
dbo.Employees
Indexes
PK_Employees
LastName
PostalCode
Relationships
FK_Employees_Employees
dbo.EmployeeTerritories
Indexes
PK_EmployeeTerritories
_WA_Sys_TerritoryID_36B12243
Relationships
FK_EmployeeTerritories_Employees
FK_EmployeeTerritories_Territories
dbo.Order Details
Indexes
PK_Order_Details
OrderID
OrdersOrder_Details
ProductID
ProductsOrder_Details
Relationships
FK_Order_Details_Orders
FK_Order_Details_Products
dbo.Orders
Indexes
PK_Orders
CustomerID
CustomersOrders
EmployeeID
EmployeesOrders
OrderDate
ShippedDate
ShippersOrders
ShipPostalCode
Relationships
FK_Orders_Customers
FK_Orders_Employees
FK_Orders_Shippers
dbo.Products
Indexes
PK_Products
CategoriesProducts
CategoryID
ProductName
SupplierID
SuppliersProducts
Relationships
FK_Products_Categories
FK_Products_Suppliers
dbo.Region
Indexes
PK_Region
dbo.Shippers
Indexes
PK_Shippers
dbo.Suppliers
Indexes
PK_Suppliers
CompanyName
PostalCode
dbo.Territories
Indexes
PK_Territories
_WA_Sys_RegionID_35BCFE0A
Relationships
FK_Territories_Region
Views
dbo.Alphabetical list of products
dbo.Category Sales for 1997
dbo.Current Product List
dbo.Customer and Suppliers by City
dbo.Invoices
dbo.Order Details Extended
dbo.Order Subtotals
dbo.Orders Qry
dbo.Product Sales for 1997
dbo.Products Above Average Price
dbo.Products by Category
dbo.Quarterly Orders
dbo.Sales by Category
dbo.Sales Totals by Amount
dbo.Summary of Sales by Quarter
dbo.Summary of Sales by Year
Stored Procedures
dbo.CustOrderHist
dbo.CustOrdersDetail
dbo.CustOrdersOrders
dbo.Employee Sales by Country
dbo.Sales by Year
dbo.SalesByCategory
dbo.Ten Most Expensive Products
Users
dbo
guest
Roles
public
db_owner
Server Info
Logins
project
sa
BUILTIN\Administrators
About