WebStorm
 
2022.2
Shortcuts: Windows
Get WebStorm
You are viewing the documentation for an earlier version of WebStorm.
  1. Reference
  2. Dialogs
  3. Confirm drop dialog

Confirm drop dialog

Last modified: 05 October 2021

This feature is available with the Database Tools and SQL plugin installed on the Settings/Preferences | Plugins page, tab Marketplace, as described in Installing plugins from JetBrains repository.

Please note that it is a paid plugin.

Click the Database tool window and select Edit | Drop, or select Drop from the context menu, or press Delete.

Click OK to remove the selected item or items, or click the Open query in console icon to copy the SQL statement or statements into the query console.

the Open in console icon

Item

Description

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 syntax

Ensures that the table exists.

Use DROP CASCADE syntax

Deletes 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.

Open query in console icon

Copy the statements into the corresponding query console and close the dialog.