Delete all rows from database by using single query?

Question

Possible Duplicate:
How to delete all rows from all tables in a SQL Server database?

I want to delete all rows from a SQL Server 2005 database.

Can anyone to define a procedure to delete all rows from database by using single query?

1. Select all table names from your database, 2. Dynamically generate sql statements for deleting all rows, 3. Execute. — MD Sayem Ahmed, May 31 '12 at 10:27

score 0 · Accepted Answer · answered May 31 '12 at 10:39

0

In that case, this will work:

EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
GO
EXEC sp_MSForEachTable 'DELETE FROM ?'
GO
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
GO

thanks @MAT

answered May 31 '12 at 10:39

Umair Noor

442
4
17

score -2 · Answer 2 · answered May 31 '12 at 10:28

-2

Have you tried : delete * FROM database.* ?

answered May 31 '12 at 10:28

tinka

1
1

1

That is not valid syntax in SQL Server.. – Blorgbeard May 31 '12 at 10:34

Delete all rows from database by using single query?

2 Answers2

Linked