Drop sequences for Oracle
Par batmat le lundi 22 décembre 2008, 09:41 - Technique - Lien permanent
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.


Commentaires