Remove all entries in all tables with one query

Asked May 26 '15 at 07:46

Active May 26 '15 at 07:53

Viewed 61 times

Is there a single SQL statement that I can use to delete all the entries from a database?

I want an SQL statement equivalent to running the DELETE FROM tbl_name; on all the tables in the database.

If such a statement doesn't exist, why not? It seems like something people would want to do.

edited May 26 '15 at 07:53

mps98

asked May 26 '15 at 07:46

Forrest Keppler

1

Why would you want to completely empty your entire database? – Barmar May 26 '15 at 07:49
BTW, `TRUNCATE tbl_name` is a better way to empty a table. – Barmar May 26 '15 at 07:50
Im creating a database frontend, and want to provide administrators with the ability to reset the database to default. – Forrest Keppler May 26 '15 at 07:52

0 Answers0