Console

The settings in this section relate to showing various information in database consoles.

Item

Description

Show query results in new tab

You can select to view query results on individual tabs, or on one and the same tab.

If the checkbox is selected, a new tab with the query result will open each time you run a query (SELECT). In this way, you can keep the results of all the queries that you have run.

If this checkbox is not selected, the same tab is used to show your query results. When you run a query, the information on the tab is updated to show the result, and a new tab doesn't open.

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

If this checkbox is not selected, the information about the errors is shown only in the output pane. If, in addition, you want the error notification bar to appear in the input pane, select the checkbox.

The error notification bar may be particularly useful when running sequences of SQL statements. If an error occurs in such cases, the error notification bar lets you select how to react.

If this option is on, the new schema or database is shown in the Database tool window right away. Deleted schemas and databases are immediately removed from the Schemas popup in the Database tool window and from the list on the Schemas tab in the Data Sources and Drivers dialog.

If this option is off, the new schema or database isn't shown unless you visualize it manually, see Showing and hiding schemas. Deleted schemas and databases that were selected for viewing will stay in the corresponding lists unless deselected.

Execute in Console

This section contains the options for the Execute command. You can assign up to three different execute configurations, each with its own behavior and shortcut.

Item

Description

When inside a statement execute

If the cursor is inside a statement, the following options are available:

Ask what to execute. A list of statements that can be run is shown and you can select the statement or statements.

Smallest statement. The smallest of the possible statements is executed. For example, when the cursor is inside a subquery, the subquery is executed.

Largest statement. The largest possible statement is executed. For example, when the cursor is inside a subquery, an outer statement is executed.

Largest statement or batch. For Transact-SQL (SQL Server and Sybase), the current batch of statements is executed. For all other dialects - the same as the previous option.

Whole script. All the statements are executed.

otherwise execute

If the cursor is outside of a statement, e.g. on a blank line or within a comment, the following options are available:

Nothing. None of the statements is executed.

Whole script. All the statements are executed.

Everything below caret. All the statements after the cursor position are executed.

for selection execute

If something is currently selected, the following options are available:

Exactly as one statement. Exactly what is selected is executed as a single statement.

Exactly as statements. Exactly what is selected is executed. If the selection contains more than one statement, the statements are executed as separate statements.

Smart expand to script. If there is at least one statement border within the selection, the selection is expanded to form a sequence of valid statements. This sequence is then executed.