select ' drop table ' || tname || ';' from tab;