Name |
Value |
Not For Replication |
|
ProductSubcategory column |
ProductCategory column |
Type |
ProductCategoryID |
ProductCategoryID |
int |
Name |
Value |
MS_Description |
Foreign key constraint referencing ProductCategory.ProductCategoryID. |
/ -->
ALTER TABLE [Production].[ProductSubcategory]
WITH CHECK
ADD CONSTRAINT [FK_ProductSubcategory_ProductCategory_ProductCategoryID]
FOREIGN KEY ([ProductCategoryID]) REFERENCES [Production].[ProductCategory] ([ProductCategoryID])
ALTER TABLE [Production].[ProductSubcategory]
CHECK CONSTRAINT [FK_ProductSubcategory_ProductCategory_ProductCategoryID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ProductCategory.ProductCategoryID.', 'SCHEMA', N'Production', 'TABLE', N'ProductSubcategory', 'CONSTRAINT', N'FK_ProductSubcategory_ProductCategory_ProductCategoryID'
GO
|