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.