Simple is best

SET FOREIGN_KEY_CHECKS = 0; 

SET @tables = NULL;

SELECT GROUP_CONCAT(table_name) INTO @tables

  FROM information_schema.tables 

  WHERE table_schema = '[이곳에 DB명]';

SET @tables = CONCAT('DROP TABLE ', @tables);

PREPARE stmt FROM @tables;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

SET FOREIGN_KEY_CHECKS = 1;