2012-09-25

Drop a list of MySQL tables using schema meta-data


You can select tables you would like to drop from MySQL's meta schema. In this case I want to drop all tables of the user/schema user.

select concat('drop table ', table_name, ';') from information_schema.tables where table_schema = 'user';

Provides following output:
'drop table booking;'
'drop table bookings;'
'drop table languages;'
'drop table report;'
'drop table reports;'
'drop table resource;'
'drop table resource_languages;'
'drop table resources;'
'drop table resources_languages;'
'drop table session;'
'drop table sessions;'
'drop table slot;'
'drop table slots;'
'drop table user;'