Relationship:
IMFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID
on
SpecialOfferProduct_inmem
Relationship properties
| Name | Value |
| Not For Replication |
FK columns
| SpecialOfferProduct_inmem column | SpecialOffer_inmem column | Type |
| SpecialOfferID | SpecialOfferID | int |
SQL
ALTER TABLE [Sales].[SpecialOfferProduct_inmem] WITH CHECK ADD CONSTRAINT [IMFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID] FOREIGN KEY ([SpecialOfferID]) REFERENCES [Sales].[SpecialOffer_inmem] ([SpecialOfferID]) ALTER TABLE [Sales].[SpecialOfferProduct_inmem] CHECK CONSTRAINT [IMFK_SpecialOfferProduct_SpecialOffer_SpecialOfferID] GO |
See also