mysql 테이블 전체삭제

-- Drop all tables

SELECT

    CONCAT('DROP TABLE ',' `',TABLE_SCHEMA,'`.`',TABLE_NAME,'`;') AS stmt

FROM information_schema.tables

WHERE TABLE_SCHEMA = 'DB명'

 

끝