Re: DROP TABLE with jolly char

[Roland Bouman]

What version of mysql are you using? If >= 5.02, you could use the information schema:

SELECT concat('DROP TABLE ',table_name,';')
FROM information_schema.tables
WHERE table_schema = '<name of your database>'

or

WHERE table_schema = SCHEMA()`

for the current database.

This generates the code you need to drop the tables.