Share via


ProductCategory Table (AdventureWorks)

Contains high-level product categorization of Adventure Works Cycles products, for example: bikes, components, clothing, or accessories.

ProductCategory Table Definition

The ProductCategory is contained in the Production schema.

Column Data type Nullability Description

ProductCategoryID

int

Not null

Primary key for ProductCategory rows.

Name

Name (user-defined type)

nvarchar(50)

Not null

Category description.

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.

See Also

Reference

Product Table (AdventureWorks)
ProductSubcategory Table (AdventureWorks)
ProductModel Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance