Is there a way for SQL Developer to generate a DROP statement when exporting the DDL for a table?
The drop preference will be applied when generating the DDL for scripting purposes, but not for the table editor.
So to get the table CREATE DDL script with a DROP TABLE command, right-click on your table, and send the ‘Quick DDL’ to a worksheet, clipboard, or file.
There’s also a ‘Cascade Drops‘ preference, which is a bit more forceful when it comes to foreign key constraints that reference the object being dropped.
You’ll notice on the preferences page you can also turn off things like storage – here’s the script again with storage disabled.
If you want even more control over the DDL being generated, export your object(s) to a data model and generate the DDL from there
Like, maybe you don’t like quoted object names in your DDL – like me 🙂