Relationship: FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID on SalesOrderDetail

CollapseAll image

Collapse image Relationship properties


 Name   Value 
 Not For Replication   

Collapse image FK columns


SalesOrderDetail column SpecialOfferProduct column Type
SpecialOfferID SpecialOfferID int
ProductID ProductID int

Collapse image Extended properties


Name  Value 
MS_Description Foreign key constraint referencing SpecialOfferProduct.SpecialOfferIDProductID.
/ -->

Collapse image SQL


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

Collapse image See also


[Sales].[SalesOrderDetail]

[Sales].[SpecialOfferProduct]