Objects - Generate SQL to drop all stored objects for the current user/schema login |
-- -- dropobjects.sql -- -- Objects - Generate SQL to drop all stored objects for the current user/schema login -- -- Usage: @dropobjects -- set heading off set pagesize 0 spool dropobjects.ddl select 'drop '||object_type||' '||object_name||';' from user_objects where object_type in ('VIEW','PROCEDURE','TRIGGER','PACKAGE','FUNCTION') order by 1; spool off |