Northwind schema

Tables and views

Explore the native recordsets with their real names, schema, relationships, row counts, and direct downloads.

Ctable Categories 4 columns · 0 links · 8 rows · 1 matches in other samples Ctable CustomerCustomerDemo 2 columns · 2 links · 0 rows · 2 matches in other samples Ctable CustomerDemographics 2 columns · 0 links · 0 rows · 1 matches in other samples Ctable Customers 11 columns · 0 links · 93 rows · 2 matches in other samples Etable EmployeeTerritories 2 columns · 2 links · 49 rows · 2 matches in other samples Etable Employees 18 columns · 1 links · 9 rows · 3 matches in other samples Otable Order Details 5 columns · 2 links · 2,155 rows · 2 matches in other samples Otable Orders 14 columns · 3 links · 830 rows · 4 matches in other samples Ptable Products 10 columns · 2 links · 77 rows · 3 matches in other samples Rtable Regions 2 columns · 0 links · 4 rows · 1 matches in other samples Stable Shippers 3 columns · 0 links · 3 rows · 1 matches in other samples Stable Suppliers 12 columns · 0 links · 29 rows · 1 matches in other samples Ttable Territories 3 columns · 1 links · 53 rows · 2 matches in other samples Aview Alphabetical list of products 11 columns · 0 links · 69 rows Cview Category Sales for 1997 2 columns · 0 links · 0 rows Cview Current Product List 2 columns · 0 links · 69 rows Cview Customer and Suppliers by City 4 columns · 0 links · 122 rows Iview Invoices 26 columns · 0 links · 2,155 rows Oview Order Details Extended 7 columns · 0 links · 2,155 rows Oview Order Subtotals 2 columns · 0 links · 830 rows Oview Orders Qry 20 columns · 0 links · 830 rows Pview Product Sales for 1997 3 columns · 0 links · 0 rows Pview ProductDetails_V 14 columns · 0 links · 77 rows Pview Products Above Average Price 2 columns · 0 links · 25 rows Pview Products by Category 5 columns · 0 links · 69 rows Qview Quarterly Orders 4 columns · 0 links · 0 rows Sview Sales Totals by Amount 4 columns · 0 links · 0 rows Sview Sales by Category 4 columns · 0 links · 0 rows Sview Summary of Sales by Quarter 3 columns · 0 links · 809 rows Sview Summary of Sales by Year 3 columns · 0 links · 809 rows

Relationship map

How recordsets connect.

13 foreign keys
CustomerCustomerDemoCustomerTypeIDCustomerDemographicsCustomerTypeID
CustomerCustomerDemoCustomerIDCustomersCustomerID
EmployeeTerritoriesTerritoryIDTerritoriesTerritoryID
EmployeeTerritoriesEmployeeIDEmployeesEmployeeID
EmployeesReportsToEmployeesEmployeeID
Order DetailsProductIDProductsProductID
Order DetailsOrderIDOrdersOrderID
OrdersShipViaShippersShipperID
OrdersCustomerIDCustomersCustomerID
OrdersEmployeeIDEmployeesEmployeeID
ProductsSupplierIDSuppliersSupplierID
ProductsCategoryIDCategoriesCategoryID
TerritoriesRegionIDRegionsRegionID