Disable and Enable All constraints

Exec Sp_Msforeachtable @command1="Alter Table? Nocheck Constraint All"--//Enable EXEC sp_MSforeachtable @command1="ALTER TABLE ? CHECK CONSTRAINT ALL"

Comments