AdventureWorks Data Dictionary

The topics in this section describe the tables in the AdventureWorks sample database.


The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, places, or events is intended or should be inferred.

In This Section

Address Table

ProductModelProductDescriptionCulture Table

AddressType Table

ProductPhoto Table

AWBuildVersion Table

ProductProductPhoto Table

BillOfMaterials Table

ProductReview Table

Contact Table

ProductSubcategory Table

ContactCreditCard Table

ProductVendor Table

ContactType Table

PurchaseOrderDetail Table

CountryRegion Table

PurchaseOrderHeader Table

CountryRegionCurrency Table

SalesOrderDetail Table

CreditCard Table

SalesOrderHeader Table

Culture Table

SalesOrderHeaderSalesReason Table

Currency Table

SalesPerson Table

CurrencyRate Table

SalesPersonQuotaHistory Table

Customer Table

SalesReason Table

CustomerAddress Table

SalesTaxRate Table

DatabaseLog Table

SalesTerritory Table

Department Table

SalesTerritoryHistory Table

Document Table

ScrapReason Table

Employee Table

Shift Table

EmployeeDepartmentHistory Table

ShipMethod Table

EmployeePayHistory Table

ShoppingCartItem Table

ErrorLog Table

SpecialOffer Table

Illustration Table

SpecialOfferProduct Table

Individual Table

StateProvince Table

JobCandidate Table

Store Table

Location Table

StoreContact Table

Product Table

TransactionHistory Table

ProductCategory Table

TransactionHistoryArchive Table

ProductCostHistory Table

UnitMeasure Table

ProductDescription Table

Vendor Table

ProductDocument Table

VendorAddress Table

ProductInventory Table

VendorContact Table

ProductListPriceHistory Table

WorkOrder Table

ProductModel Table

WorkOrderRouting Table

ProductModelIllustration Table


See Also

Other Resources

Installing AdventureWorks Sample Databases and Samples

Help and Information

Getting SQL Server 2005 Assistance