sqlserver清空所有表数据

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 ?'

转载于:https://www.cnblogs.com/jiaobaobao/p/10972946.html

相关资源：删除一个数据库里所有表的数据