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