论坛 › SQL Server › sql server disable all constraints and triggers

fenghzy 发表于 2016-11-6 01:42:08

sql server disable all constraints and triggers

　　USE
　　EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL"
GO
　　EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO
　　Reference: http://www.sqlusa.com/bestpractices2005/disabletriggerconstraint/

查看完整版本: sql server disable all constraints and triggers