At least a few months ago I was able to select all the tables and sequences in an Oracle schema from the Database view, choose Drop and it would generate a SQL statements that would include dropping foreign key constraints as well. Otherwise the drop statements would fail due to the constraints.
I remember Datagrip would create these required drop constraint statements only when I selected the tables and sequences in a specific order. If I did it in another way/order there would only be the drop table and drop sequence statements without the drop constraint statements.
Meanwhile my brain has forgotten the order and Datagrip has upgraded and I cannot figure out how to tell Datagrip to do its magic and add the drop constraints for me.
I also noticed the resulting SQL now also include a forward slash on a separate line after each drop statement as well like in a script instead of a list of statements with semicolons. I remember this being different previously but I might very well be wrong about this.
What's the correct way to tell Datagrip to drop selected items and also generate any other necessary drop statements too. I know this feature existed a few minor versions / months ago.
Build #DB-173.4301.31, built on January 17, 2018
Licensed to XXXXXXXXXXXXXX
Subscription is active until November 29, 2018
JRE: 1.8.0_152-release-1024-b11 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o