Oracle - Error in table script generation

6 views
Skip to first unread message

Paolo G

unread,
Apr 14, 2022, 9:49:21 AM4/14/22
to SQL Workbench/J - DBMS independent SQL tool
For Tables, the "SQL source" in the "Database Explorer" generates

DROP TABLE %fq_name% CASCADE CONSTRAINTS PURGE;

at the beginning. I.e. it shows what appears to be a placeholder instead of the table name.

Thomas Kellerer

unread,
Apr 14, 2022, 11:54:47 AM4/14/22
to sql-wo...@googlegroups.com
Thanks, I will fix that.

In the meantime, you can fix it yourself by adding the following line to workbench.settings

workbench.db.oracle.drop.table=DROP TABLE %fq_table_name% %cascade% PURGE

Regards
Thomas
Reply all
Reply to author
Forward
0 new messages