Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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