SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Development

Samples

AdventureWorks Sample Databases

AdventureWorks Sample OLTP Database

AdventureWorks Data Dictionary

Address Table (AdventureWorks)

AddressType Table (AdventureWorks)

AWBuildVersion Table (AdventureWorks)

BillOfMaterials Table (AdventureWorks)

Contact Table (AdventureWorks)

ContactCreditCard Table (AdventureWorks)

ContactType Table (AdventureWorks)

CountryRegionCurrency Table (AdventureWorks)

CountryRegion Table (AdventureWorks)

CreditCard Table (AdventureWorks)

Culture Table (AdventureWorks)

Currency Table (AdventureWorks)

CurrencyRate Table (AdventureWorks)

Customer Table (AdventureWorks)

CustomerAddress Table (AdventureWorks)

DatabaseLog Table (AdventureWorks)

Department Table (AdventureWorks)

Document Table (AdventureWorks)

Employee Table (AdventureWorks)

EmployeeAddress Table (AdventureWorks)

EmployeeDepartmentHistory Table (AdventureWorks)

EmployeePayHistory Table (AdventureWorks)

ErrorLog Table (AdventureWorks)

Illustration Table (AdventureWorks)

Individual Table (AdventureWorks)

JobCandidate Table (AdventureWorks)

Location Table (AdventureWorks)

Product Table (AdventureWorks)

ProductCategory Table (AdventureWorks)

ProductCostHistory Table (AdventureWorks)

ProductDescription Table (AdventureWorks)

ProductDocument Table (AdventureWorks)

ProductInventory Table (AdventureWorks)

ProductListPriceHistory Table (AdventureWorks)

ProductModel Table (AdventureWorks)

ProductModelIllustration Table (AdventureWorks)

ProductModelProductDescriptionCulture Table (AdventureWorks)

ProductPhoto Table (AdventureWorks)

ProductProductPhoto Table (AdventureWorks)

ProductReview Table (AdventureWorks)

ProductSubcategory Table (AdventureWorks)

ProductVendor Table (AdventureWorks)

PurchaseOrderDetail Table (AdventureWorks)

PurchaseOrderHeader Table (AdventureWorks)

SalesOrderDetail Table (AdventureWorks)

SalesOrderHeader Table (AdventureWorks)

SalesOrderHeaderSalesReason Table (AdventureWorks)

SalesPerson Table (AdventureWorks)

SalesPersonQuotaHistory Table (AdventureWorks)

SalesReason Table (AdventureWorks)

SalesTaxRate Table (AdventureWorks)

SalesTerritory Table (AdventureWorks)

SalesTerritoryHistory Table (AdventureWorks)

ScrapReason Table (AdventureWorks)

Shift Table (AdventureWorks)

ShipMethod Table (AdventureWorks)

ShoppingCartItem Table (AdventureWorks)

SpecialOffer Table (AdventureWorks)

SpecialOfferProduct Table (AdventureWorks)

StateProvince Table (AdventureWorks)

Store Table (AdventureWorks)

StoreContact Table (AdventureWorks)

TransactionHistory Table (AdventureWorks)

TransactionHistoryArchive Table (AdventureWorks)

UnitMeasure Table (AdventureWorks)

Vendor Table (AdventureWorks)

VendorAddress Table (AdventureWorks)

VendorContact Table (AdventureWorks)

WorkOrder Table (AdventureWorks)

WorkOrderRouting Table (AdventureWorks)

Minimize

This topic has not yet been rated - Rate this topic

ProductDescription Table (AdventureWorks)

SQL Server 2008

SQL Server 2005

Contains the product descriptions in several languages.

ProductDescription Table Definition

The ProductDescription table is contained in the Production schema.

Column	Data type	Nullability	Description
ProductDescriptionID	int	Not null	Primary key for ProductDescription rows.
Description	nvarchar(400)	Not null	Description of the product.
rowguid	uniqueidentifier ROWGUIDCOL	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

Reference

Culture Table (AdventureWorks)

ProductModel Table (AdventureWorks)

ProductModelProductDescriptionCulture Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.