Usually I open Terminal.app and connect to a remote MySQL database.
Then I use this command to drop a table:
mysql> drop table [table name];
But what I need is the command line to drop all tables in the database.
If I use:
mysql> drop database [database name];
I'll destroy the database completely and I won't be able to create tables again. Am I right?