Notiz
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Iech unzemellen oder Verzeechnesser ze änneren.
Zougrëff op dës Säit erfuerdert Autorisatioun. Dir kënnt probéieren, Verzeechnesser ze änneren.
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