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