Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft