drop cascade tables in a database code example

Example 1: mysql drop table cascade

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

Example 2: drop cascade

drop table if exists table_name cascade;