mysql

SELECT CONCAT('drop table  ', t.table_name ,' ;') as table_name FROM information_schema.TABLES t WHERE t.TABLE_SCHEMA='test2'



SELECT CONCAT('ALTER TABLE ', t.table_name ,' DROP COLUMN exp_field;') as table_name FROM information_schema.TABLES t WHERE t.TABLE_SCHEMA='test2'