The Database section contains database and SQL settings.
Execute in console
|Prefer database view over DDL editor|
Select the checkbox to go from a reference to a definition in the Database tool window. Clear the checkbox to go from a reference in the editor to a DDL definition.
To jump from a reference in the editor to a to a definition in the Database tool window, press Ctrl and click a reference.
|Prefer data editor over DDL editor|
Clear the checkbox to open a DDL definition of the object from the Database tool window. Select the checkbox to see the table view of the definition.
To open a DDL definition or a table view, double-click the object in the Database tool window.
The settings in this section relate to showing various information in database consoles.
|When inside statement execute|
If the cursor is inside a statement, perform the following actions:
If the cursor is outside of a statement (for example, on a blank line or within a comment), perform one of the following actions:
|for selection execute|
If the code is selected (highlighted), perform one of the following options:
|Open results in new tab|
You can select to view query results on individual tabs, or on one and the same tab. For the single tab, the tab is updated for each query.
Select the checkbox to create a new tab with query results each time you run the
If the checkbox is cleared, the same tab is used to show query results. Information on the tab is updated to show the result.
In this case, when you get the result that you want to keep, you can pin the tab to the tool window () on the toolbar or Pin Tab in the context menu for the tab).
|Show error notifications in editor|
Clear this checkbox to display information about errors in the output pane only. Select the checkbox to display errors in output and input panes.
The error notification bar might be useful when you run sequences of SQL statements. If an error occurs, you see a notification bar with possible actions to fix the error.
|Review parameters before execution|
When you run a statement with parameters, IntelliJ IDEA saves parameter values in memory. Select this checkbox and next time you execute the statement, IntelliJ IDEA will show you the last used parameter values. You can change them before running the statement.
Clear this checkbox and IntelliJ IDEA will execute the statement immediately without showing you the parameter values.
|Always show console toolbar in editor|
Select to display the console toolbar in the editor.
|Track databases/schemas creation and deletion|
When you create, delete, or rename a schema, IntelliJ IDEA updates the list of available schemas in the introspection scope window. To see the introspection scope, click the button near the data source name in the Database tool window.
|Show warning before running potentially unsafe queries|
Select to display warnings for potentially unsafe queries.
If you forgot to put the
|Create title for results from comment before query|
You can define a tab title in the comment section before the query. In the Treat text as title after field, you can reserve a combination of symbols or characters, and any text after this combination will be treated as a tab title. By default, no combination is used, so any text after
To disable this feature, open settings Ctrl+Alt+S, navigate to Create title for results from comment before query checkbox., and clear the
Open settings by pressing Ctrl+Alt+S, navigate to.
In the Treat text as title after field, define a combination for tab titles.
|Show first N rows documentation||Limit number of rows for a quick documentation popup. To see quick documenation, press Ctrl+Q.|
|Always show qualified names for database objects|
Adds a schema name to the table name for the tab. If the checkbox is selected, double-click the table in the Database tool window to see a qualified tab name.
|Confirm cancellation for dialogs that modify schema|
Show a confirmation dialog when you close Add Database, Add Schema, Create New Table, or Modify Table dialogs. Close means clicking Cancel or pressing Escape. If the checkbox is cleared, the dialog closes instantly.