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