thorpedosg

ypsAqqVu

Aug 6th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. IF OBJECT_ID('FK_ParadisePapersAddresses_CountriesInfo') is null
  2. BEGIN
  3. ALTER TABLE dbo.ParadisePapersAddresses
  4. WITH NOCHECK
  5. ADD CONSTRAINT FK_ParadisePapersAddresses_CountriesInfo FOREIGN KEY (n_country_codes)
  6. REFERENCES dbo.CountriesInfo([alpha-3]);
  7. END
  8.  
  9. IF OBJECT_ID('FK_ParadisePapersIntermediaries_CountriesInfo') is null
  10. BEGIN
  11. ALTER TABLE dbo.ParadisePapersIntermediaries
  12. WITH NOCHECK
  13. ADD CONSTRAINT FK_ParadisePapersIntermediaries_CountriesInfo FOREIGN KEY (n_country_codes)
  14. REFERENCES dbo.CountriesInfo([alpha-3]);
  15. END
  16.  
  17. IF OBJECT_ID('FK_ParadisePapersOfficers_CountriesInfo') is null
  18. BEGIN
  19. ALTER TABLE dbo.ParadisePapersOfficers
  20. WITH NOCHECK
  21. ADD CONSTRAINT FK_ParadisePapersOfficers_CountriesInfo FOREIGN KEY (n_country_codes)
  22. REFERENCES dbo.CountriesInfo([alpha-3]);
  23. END
  24.  
  25. IF OBJECT_ID('FK_ParadisePapersOthers_CountriesInfo') is null
  26. BEGIN
  27. ALTER TABLE dbo.ParadisePapersOthers
  28. WITH NOCHECK
  29. ADD CONSTRAINT FK_ParadisePapersOthers_CountriesInfo FOREIGN KEY (n_country_codes)
  30. REFERENCES dbo.CountriesInfo([alpha-3]);
  31. END
Add Comment
Please, Sign In to add comment