Advanced Search

DROP ALL TABLES / SEQUENCES

/ Published in: ActionScript 3
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.