Re: Deleting all data
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 26 Jul 2007 21:37:08 +0000 (UTC)
Tmuld (tmuldoon@xxxxxxxxxxx) writes:
Is there a way to delete all data from a database - all tables and all
tables excluding system tables?
A brute force method is to run
SELECT 'DELETE ' + name FROM sysobjects WHERE type = 'U'
Copy and paste the result into a query window, and the run it over and
over again, until there are no error messages. This presumes that the
only errors you get are from foreign keys. If you have triggers that
object to the deletion, you need to disable these.
Another alternative is build an empty database from scripts, either
taken from version control or generated by Enterprise Manager.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Deleting all data
- From: Tmuld
- Deleting all data
- Prev by Date: (SSRS) Generate SQL by automation?
- Next by Date: Re: Can I manage MSDE with SSMS??
- Previous by thread: Deleting all data
- Next by thread: Re: Deleting all data
- Index(es):
Relevant Pages
|
