Drop all SQL tables

drop-tables.txt

mysqldump --add-drop-table --no-data -u root -p DB_NAME | grep 'DROP TABLE' > drop_all_tables.sql
mysql -u root -p DB_NAME < drop_all_tables.sql

===================

drop database DB_NAME;

===================

SET FOREIGN_KEY_CHECKS = 0;

SELECT
    table_name
FROM
    information_schema.tables
WHERE
    table_schema = db_name;
And delete all tables on by one from the list:

DROP TABLE IF EXISTS table1;

DROP TABLE IF EXISTS table2;

DROP TABLE IF EXISTS table3;
Remember to turn on foreign key constraint after it’s done:

SET FOREIGN_KEY_CHECKS = 1;