SQL SERVER 数据库清空语句 忽略外键 触发器 等

1 USE  ClothesShop
2 EXECUTE sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
3 EXECUTE sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
4 EXECUTE sp_MSForEachTable 'DELETE FROM ?'
5 EXECUTE sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
6 EXECUTE sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'
7 EXECUTE sp_MSFOREACHTABLE 'SELECT * FROM ?'
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/binsys/p/2711204.html