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