AdventureWorks Data Dictionary

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

Important

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