http://phpcode8.com/lamp/mysql-lamp/mysql-empty-tables.html

SELECT concat(‘DROP TABLE IF EXISTS ‘, table_name, ‘;')

FROM information_schema.tables

WHERE table_schema = ‘pentaho0’;