Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Contains product subcategories, for example: mountain bikes, wheels, gloves, helmets, and cleaners.
ProductSubcategory Table Definition
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. |
See Also
Reference
Product Table (AdventureWorks)
ProductCategory Table (AdventureWorks)
ProductModel Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary