Truncating all Tables in a particular Database.

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


     I dont know whether this post has been already posted or not, but
I couldnt found any.

     Is it possible to empty all data in a database containing >300
tables? What is the best solution to truncate all the tables in a
database? As I know one way is to export the database structure, drop
the database, recreate the database and reimport the database
structure. Is there any other way to do it ?

Site Timeline