Table: 'Production.ProductCategory'

4 fields. 136 bytes.

High-level product categorization.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ProductCategoryIDint identity int Not nullPrimary key for ProductCategory records. 
NameName nvarchar(50) Not nullCategory description. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.ProductCategory'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Production.ProductCategory', 3 items

Index NameDescriptionClusteredUniqueFields
PK_ProductCategory_ProductCategoryIDClustered index created by a primary key constraint.YesYesProductCategoryID
AK_ProductCategory_NameUnique nonclustered index.NoYesName
AK_ProductCategory_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Production.ProductCategory', 1 item

uProductCategoryAFTER UPDATE trigger setting the ModifiedDate column in the ProductCategory table to the current date.after Update Yes

Dependencies for table 'Production.ProductCategory', 1 item

Object NameTypeField Name