How delete all the data in all the tables in your 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.
Written on March 15, 2006
A blog of software development, .NET and other interesting things
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.