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.