Sayfalar

12 Eylül 2014 Cuma

How to disabling all constraint in MsSql database.

EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

How to enabling all constraint in MsSql database.

exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"