Select concat('DROP TABLE database_name.', table_name,';') from information_schema.TABLES where table_schema='database_name';