AdventureWorks to Northwind Table Comparison
Some tables in the AdventureWorks sample database are similar in structure and content to tables in the Northwind sample database. You can use the following table to convert queries that use Northwind to queries that use AdventureWorks by selecting columns from the appropriate AdventureWorks tables. For example, if a query references the Orders table in Northwind, a similar query can be written for AdventureWorks by using the Sales.SalesOrderHeader table. Notice that AdventureWorks uses schema names other than dbo. The schema names are included with the table names and must be specified when performing queries against the tables. For more information, see Schemas in AdventureWorks.
| Northwind | AdventureWorks | Comments |
|---|---|---|
Categories |
Production.ProductCategory |
See ProductSubCategory and ProductModel for a more detailed categorization. |
Customers |
Sales.Customer Join with Sales.Individual and Sales.Store |
AdventureWorks contains two types of customers: stores (resellers) and individuals (consumers). |
Customer Demographics |
Sales.Individual Sales.Store |
See the Demographics column (xml) in the Sales.Individual and Sales.Store tables. |
Employees |
HumanResources.Employee Join with Person.Contact |
|
Employee Territories |
Sales.SalesPerson |
Sales.SalesPerson maps sales representatives to sales territories. See also the Sales.SalesTerritory and Employees tables. |
Orders |
Sales.SalesOrderHeader |
|
Order Details |
Sales.SalesOrderDetail |
|
Products |
Production.Product |
|
Region |
Sales.SalesTerritory |
The RegionDescription column is the equivalent of the Group column in Sales.SalesTerritory. |
Shippers |
Purchasing.ShipMethod |
|
Suppliers |
Purchasing.Vendor |
|
Territories |
Sales.SalesTerritory |
The TerritoryDescription column is the equivalent of the Name column in Sales.SalesTerritory. |
See Also
Concepts
AdventureWorks to pubs Table Comparison
Other Resources
AdventureWorks Sample OLTP Database
Downloading Northwind and pubs Sample Databases
AdventureWorks Data Dictionary