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