EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' --禁用
EXEC sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL' -- 启用
EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' --禁用
EXEC sp_msforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL' -- 启用
转载于:https://www.cnblogs.com/shiningrise/p/4514829.html