Skip to content

Instantly share code, notes, and snippets.

@sandcastle

sandcastle/drop_all_user_objects.sql

Created February 26, 2015 06:53
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sandcastle/204a2752da437e564dab to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sandcastle/204a2752da437e564dab to your computer and use it in GitHub Desktop.
Download ZIP
Generates an oracle script to drop all objects within a schema.
Raw
drop_all_user_objects.sql
select 'drop '||lower(object_type)||' '|| object_name||decode(object_type,'TABLE',' cascade constraints;',';')
from user_objects;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment