Adds foreign key in tblDisplay for lnkclientID which exists in tblClient as IDClient
|
1 2 3 4 5 6 7 8 9 10 |
-- -- Adds foreign in tbldisplay ALTER TABLE [dbo].[tblDisplay] WITH CHECK ADD CONSTRAINT [FK_tblClient_tblDisplay] FOREIGN KEY([lnkClientID]) REFERENCES [dbo].[tblClient] ([IDClient]) -- |
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] |