How delete all the data in all the tables in your database

15th March 2006

Adi shared a useful SQL approach for deleting all data from every table in a database.

Adi has a nice way of removing all the data. The only change I made was to use “DELETE FROM” instead of “TRUNCATE TABLE” so that it works with foreign keys.