mysql:
select CONCAT('drop table ',table_name,';') from information_schema.tables
where table_schema='PIKE' and table_type='base table' and table_name like 'TPM%';
oracle:
select 'drop table '||table_name||';' from user_tables where table_name like 'TPM%';