Public snipts »
Fotinakis's
snipts » drop
showing 1-1 of 1 snipts for drop
-
∞ Drop all tables and constraints within an Oracle schema
BEGIN FOR c IN (SELECT table_name FROM user_tables) LOOP EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS'); END LOOP; END;



MySQL Stored Procedure Programming