I am trying to use the SQL Monitor to DROP all tables within a database, but not delete or DROP the whole database.

I've tried using:



AND



AND



I've searched the http://www.mysql.com web site and read most of the DROP syntax tutorials. It doesn't seem like MySQL supports wildcard characters within table names.

Anyone know if it is possible to include wildcard characters in table names????

Individually DROPping 40 tables in a database is a pain!

Thanks in advance....

Regards,

Eliot Lee