How can I drop all tables in my database?

Question

How can I drop all tables in my database ?

1) In one MYSQL command

2) Without destroying and creating the database ?

Thanks

Answer 1

Try something like this:

mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]

Neat little trick, and it works for me.

Originally suggested here.