Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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.

Community Additions

ADD
Show:
© 2015 Microsoft