清空库数据sql

最新推荐文章于 2021-07-16 11:14:29 发布

weixin_30485799

最新推荐文章于 2021-07-16 11:14:29 发布

阅读量149

点赞数

原文链接：http://www.cnblogs.com/yy1234/p/8555004.html

版权

--清空库数据
CREATE PROCEDURE sp_DeleteAllData
AS
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 ?'
GO

exec sp_DeleteAllData

转载于:https://www.cnblogs.com/yy1234/p/8555004.html