Production.ProductSubcategory

Table: 'Production.ProductSubcategory'

5 fields. 140 bytes.

Product subcategories. See ProductCategory table.

Field Name Data Type Size Original Type Default Nullable Description Check

ProductSubcategoryID int identity int Not null Primary key for ProductSubcategory records.

ProductCategoryID int Not null Product category identification number. Foreign key to ProductCategory.ProductCategoryID.

Name Name nvarchar(50) Not null Subcategory description.

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Original Type	Default	Nullable	Description
ProductSubcategoryID	int identity	int		Not null	Primary key for ProductSubcategory records.
ProductCategoryID	int			Not null	Product category identification number. Foreign key to ProductCategory.ProductCategoryID.
Name	Name	nvarchar(50)		Not null	Subcategory description.
rowguid	uniqueidentifier		newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime		getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductSubcategory'

Primary Key Name Field Name

PK_ProductSubcategory_ProductSubcategoryID ProductSubcategoryID

Primary Key Name	Field Name
PK_ProductSubcategory_ProductSubcategoryID	ProductSubcategoryID

Foreign keys for table 'Production.ProductSubcategory', 1 item

Foreign Primary Key Name

ProductSubcategory.ProductCategoryID ProductCategory.ProductCategoryID FK_ProductSubcategory_ProductCategory_ProductCategoryID

Foreign	Primary	Key Name
ProductSubcategory.ProductCategoryID	ProductCategory.ProductCategoryID	FK_ProductSubcategory_ProductCategory_ProductCategoryID

Indexes for table 'Production.ProductSubcategory', 3 items

Index Name Description Clustered Unique Fields

PK_ProductSubcategory_ProductSubcategoryID Clustered index created by a primary key constraint. Yes Yes ProductSubcategoryID

AK_ProductSubcategory_Name Unique nonclustered index. No Yes Name

AK_ProductSubcategory_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_ProductSubcategory_ProductSubcategoryID	Clustered index created by a primary key constraint.	Yes	Yes	ProductSubcategoryID
AK_ProductSubcategory_Name	Unique nonclustered index.	No	Yes	Name
AK_ProductSubcategory_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Production.ProductSubcategory', 1 item

Name Description Type Enabled

uProductSubcategory AFTER UPDATE trigger setting the ModifiedDate column in the ProductSubcategory table to the current date. after Update Yes

Name	Description	Type	Enabled
uProductSubcategory	AFTER UPDATE trigger setting the ModifiedDate column in the ProductSubcategory table to the current date.	after Update	Yes

Dependencies for table 'Production.ProductSubcategory', 1 item

Object Name Type Field Name

Production.uProductSubcategory trigger N/A