EXEC sp_MSForEachTable ‘ALTER TABLE 表名 NOCHECK CONSTRAINT ALL‘
EXEC sp_MSForEachTable ‘ALTER TABLE 表名 DISABLE TRIGGER ALL‘
EXEC sp_MSForEachTable ‘DELETE FROM 表名‘
EXEC sp_MSForEachTable ‘ALTER TABLE 表名 CHECK CONSTRAINT ALL‘
EXEC sp_MSForEachTable ‘ALTER TABLE 表名 ENABLE TRIGGER ALL‘
EXEC sp_MSFOREACHTABLE ‘SELECT * FROM 表名‘

SQL Server 2008 临时解除约束删除表中数据