Delete all table in the schema with a single command

[davey23uk]

spool drop.sql
select 'drop table ' || table_name || ';' from tabs;
spool off

@drop