Posted By

luismessias on 02/16/11


Tagged


Versions (?)

DROP ALL TABLES / SEQUENCES


 / Published in: ActionScript 3
 

  1. BEGIN
  2.  
  3. FOR c IN (SELECT table_name FROM user_tables) LOOP
  4. EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
  5. END LOOP;
  6.  
  7. FOR s IN (SELECT sequence_name FROM user_sequences) LOOP
  8. EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);
  9. END LOOP;
  10.  
  11. END;

Report this snippet  

You need to login to post a comment.