Adds a weak link (lnkAddressID) between tbl_SUB_SubscriptionContract and tbl_SUB_Address. Conditions accepted:
– ID has to exist in tblAddress
– 0 values accepted
|
1 2 3 4 5 6 7 8 9 10 |
ALTER TABLE [dbo].[tbl_SUB_SubscriptionContract] WITH NOCHECK ADD CONSTRAINT [FK_tbl_SUB_SubscriptionContract_tbl_SUB_Address] FOREIGN KEY([lnkAddressID]) REFERENCES [dbo].[tbl_SUB_Address] ([IDAddress]) ON UPDATE NO ACTION ON DELETE NO ACTION NOT FOR REPLICATION ALTER TABLE dbo.[tbl_SUB_SubscriptionContract] NOCHECK CONSTRAINT [FK_tbl_SUB_SubscriptionContract_tbl_SUB_Address] |