How to enable and disable constraints in SQL Server Leave a reply — Disable all foreign key constraints EXEC sp_MSforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT ALL” — Enable all foreign key constraints EXEC sp_MSforeachtable “ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL” Share this: Share on X (Opens in new window) X Email a link to a friend (Opens in new window) Email Share on Facebook (Opens in new window) Facebook Share on LinkedIn (Opens in new window) LinkedIn Share on WhatsApp (Opens in new window) WhatsApp Print (Opens in new window) Print Share on Reddit (Opens in new window) Reddit Share on Tumblr (Opens in new window) Tumblr Share on Pinterest (Opens in new window) Pinterest Share on Telegram (Opens in new window) Telegram Share on Mastodon (Opens in new window) Mastodon Share on Nextdoor (Opens in new window) Nextdoor Like this:Like Loading... Related