.png)
ProductSubcategory Table (AdventureWorks)
Contains product subcategories, for example: mountain bikes, wheels, gloves, helmets, and cleaners.
The ProductSubcategory table is contained in the Production schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
|
ProductSubcategoryID |
smallint |
Not null |
Primary key for ProductSubcategory rows. |
|
ProductCategoryID |
int |
Not nNull |
Product category identification number. Foreign key to ProductCategory.ProductCategoryID. |
|
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Subcategory 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. |
Reference
Product Table (AdventureWorks)ProductCategory Table (AdventureWorks)
ProductModel Table (AdventureWorks)
