Drop sequences for Oracle

Mon, Dec 22, 2008

Adam already showed how to generate all the drop table statements (impossible to trackback):

select 'drop table '||table_name||' CASCADE CONSTRAINTS;' from USER_TABLES

As I just needed to drop sequences, based on Adam’s query, here’s the necessary:

select 'drop sequence '||sequence_name||';' from USER_SEQUENCES;

Quite straightforward indeed.

Hope this helps.

— Baptiste Mathus