Return to Snippet

Revision: 41321
at February 16, 2011 07:25 by luismessias


Initial Code
BEGIN

FOR c IN (SELECT table_name FROM user_tables) LOOP
EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');
END LOOP;

FOR s IN (SELECT sequence_name FROM user_sequences) LOOP
EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);
END LOOP;

END;

Initial URL

                                

Initial Description

                                

Initial Title
DROP ALL TABLES / SEQUENCES

Initial Tags

                                

Initial Language
ActionScript 3