[MySQL] Database의 모든 테이블 삭제하는 법

SET @tables = NULL;

SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables

  FROM information_schema.tables

  WHERE table_schema = 'Database Name'; -- specify DB name here.

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

PREPARE stmt FROM @tables;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;