scott-p of MagicLamp Enterprise Repo
7/27/2017 - 2:44 PM

Generate script to delete all tables in a schema. Export the result grid as text. Must first replace all instances of '""' with '?', then '"

Generate script to delete all tables in a schema. Export the result grid as text. Must first replace all instances of '""' with '?', then '"' with '', then '?' with '"'. This will fix issues with quotations in the generated script.

Generate Drop Statements
content_copyfile_download
SELECT 'DROP TABLE "' || TABLE_NAME || '" CASCADE CONSTRAINTS;' FROM user_tables;