Sometimes you just need to disable all constraints on a database. Maybe you’re doing some massive data inserts or updates, and the constraints slow it down. Or maybe you just like living dangerously.
Don’t try this at home…
-- Disable all EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all' -- Enable all EXEC sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'