mysql drop table cascade
snippet in sql

drop table in mysql

user8201

DROP TABLE table_name;

mysql drop table cascade

user9336

SET FOREIGN_KEY_CHECKS = 0;
drop table if exists <your_1st_table>;
drop table if exists <your_2nd_table>;
SET FOREIGN_KEY_CHECKS = 1;