Relationship: ODFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID on SalesOrderDetail_ondisk

CollapseAll image

Collapse image Relationship properties


 Name   Value 
 Not For Replication   

Collapse image FK columns


SalesOrderDetail_ondisk column SpecialOfferProduct_ondisk column Type
SpecialOfferID SpecialOfferID int
ProductID ProductID int

Collapse image SQL


ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
    WITH CHECK
    ADD CONSTRAINT [ODFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]
    FOREIGN KEY ([SpecialOfferID], [ProductID]) REFERENCES [Sales].[SpecialOfferProduct_ondisk] ([SpecialOfferID], [ProductID])
ALTER TABLE [Sales].[SalesOrderDetail_ondisk]
    CHECK CONSTRAINT [ODFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]

GO

Collapse image See also


[Sales].[SalesOrderDetail_ondisk]

[Sales].[SpecialOfferProduct_ondisk]