Deletes all tables in current DB

delete_tables.sql

delimiter $$
create procedure drop_tables_like(pattern varchar(255), db varchar(255))
begin
    select @str_tables:=group_concat(table_name)
    from information_schema.tables
    where table_schema=db and table_name like pattern;

    IF @str_tables IS NOT NULL THEN
        SET @str_sql := concat('drop table ', @str_tables);
        prepare stmt from @str_sql;
        execute stmt;
        drop prepare stmt;
    END IF;
end$$

call drop_tables_like('%%', DATABASE())$$

drop procedure drop_tables_like$$

delimiter ;