g4_ 접두어로 시작하는 테이블 한방에 날리려면?

CREATE PROCEDURE `DROP_TABLES`(IN dbname VARCHAR(100), IN tblname_prefix VARCHAR(100))BEGIN    DECLARE done INT DEFAULT FALSE;    DECLARE db  VARCHAR(100);    DECLARE tbl VARCHAR(255);    DECLARE cur CURSOR FOR SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = dbname;    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;        OPEN cur;        read_loop: LOOP            FETCH cur INTO db, tbl;            IF done THEN                LEAVE read_loop;            END IF;                        IF INSTR(tbl, tblname_prefix) = 1 THEN                SET @query = CONCAT('DROP TABLE ', db, '.', tbl);                PREPARE stmt FROM @query;                EXECUTE stmt;                DEALLOCATE PREPARE stmt;                                SELECT CONCAT(db, '.', tbl, ' is dropped') removed FROM DUAL;            END IF;        END LOOP;    CLOSE cur;END