WebStorm 2020.2 Help

Confirm drop dialog

From the Database tool window:
Edit | Drop, Drop from the context menu, or Delete.

Click OK to remove the selected item or items, or click ${iconAlt} to copy the SQL statement or statements into the query console.

Qualify objects with schema names

Adds a schema name to the table name. You can qualify a table when you have two and more tables with identical names in different schemes. This option has the following parameters:

  • Auto: automatically qualifies table names if you have more than two identical table names in different schemes.

  • Never: never qualifies table names.

  • Always: always qualifies table names.

Use IF EXISTS syntaxEnsures that the table exists.
Use DROP CASCADE syntaxDeletes objects that depend on the table (such as views).
SQL Preview

The statement or statements to be run to remove the selected item or items. If necessary, you can edit the statements right in this pane.

The statements are executed when you click OK.

openQueryInConsoleIcon png Copy the statements into the corresponding query console and close the dialog.
Last modified: 19 August 2020