Truncating all Tables in a particular Database.

Truncating all Tables in a particular Database.

am 08.02.2006 07:02:19 von Kishore

Hi,

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 ?