删除SQL Server数据库中的所有数据 [英] Delete all data in SQL Server database

问题描述

如何从数据库的所有表中删除所有记录？我可以用一条SQL命令执行此操作，还是每张表只需要一条SQL命令？

How I can delete all records from all tables of my database? Can I do it with one SQL command or I need for one SQL command per one table?

推荐答案

SQLMenace的解决方案适用于我略微调整了数据的删除方式-从删除，而不是 TRUNCATE 。

SQLMenace's solution worked for me with a slight tweak to how data is deleted - DELETE FROM instead of TRUNCATE.

-- disable referential integrity
EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' 
GO 

EXEC sp_MSForEachTable 'DELETE FROM ?' 
GO 

-- enable referential integrity again 
EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL' 
GO

这篇关于删除SQL Server数据库中的所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！