Relationship: IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID on SalesOrderDetail_inmem

CollapseAll image

Collapse image Relationship properties


 Name   Value 
 Not For Replication   

Collapse image FK columns


SalesOrderDetail_inmem column SpecialOfferProduct_inmem column Type
SpecialOfferID SpecialOfferID int
ProductID ProductID int

Collapse image SQL


ALTER TABLE [Sales].[SalesOrderDetail_inmem]
    WITH CHECK
    ADD CONSTRAINT [IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]
    FOREIGN KEY ([SpecialOfferID], [ProductID]) REFERENCES [Sales].[SpecialOfferProduct_inmem] ([SpecialOfferID], [ProductID])
ALTER TABLE [Sales].[SalesOrderDetail_inmem]
    CHECK CONSTRAINT [IMFK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID]

GO

Collapse image See also


[Sales].[SalesOrderDetail_inmem]

[Sales].[SpecialOfferProduct_inmem]