mySQL - drop all the tables from a database

[Costas]

-- src - https://www.quora.com/How-do-I-drop-all-tables-in-a-MySQL-database
SELECT
CONCAT('DROP TABLE IF EXISTS ', table_name, ';') as tbl
FROM
information_schema.tables
WHERE
table_schema = 'your table';