Query consoles
Query or database consoles are SQL files in which you can compose and execute SQL statements. Unlike scratch files, consoles are attached to a data source. You can use a query console in the same way as you use a terminal. Just type and run your code.
When you create a data source, a query console is created automatically. If necessary, you can create additional consoles. Each console creates a new connection. If you do not want to create new connections, enable single connection mode.
Working with console files
Create a query console
To create a console, use one of the following actions in the Database tool window ( ).
Click a data source and select
.Right-click a data source and select
.Click a data source, press Alt+Insert, and select Console.
Click a data source, press Ctrl+Shift+F10, and select New console.
Open a console
When a console is open, you can write SQL here, run it and get the result.
In the Project tool window ( ), navigate to , double-click a console file.
In the Database tool window, click the Jump to console icon () and select a console.
Click a data source, press F4, and select the console that you need.
Rename a query console
In the Project tool window ( ), navigate to .
Expand a data source group that includes your console.
Right-click a console file and select
.
Group consoles under the data source directory
In the Project tool window ( ), navigate to .
Right-click a data source group where you want to create a new directory, select
.Specify a name of the directory.
Select and drag console files to the directory.
In the Move dialog, click OK.
Delete a query console
In the Project tool window ( ), navigate to .
Expand a data source group that includes your console.
Right-click a console file and select Delete.
Copy a console file to a new location
In the Project tool window ( ), navigate to .
Expand a data source group that includes your console.
Right-click a console file and select
.In the To directory field, specify a new location for the file.
Configuring console settings
Modify console settings
Open a console and click the Open Database Settings icon ( ).
Configuring console dialects
Change the SQL dialect in the editor
Right-click the editing area of the input pane and select Change Dialect (<current_dialect>).
Then select the target dialect.
Disable syntax error highlighting
Right-click the editing area of the input pane, select Change Dialect (<current_dialect>), and select <Generic SQL>. <Generic SQL> supports completion and highlighting for SQL keywords, table and column names. Syntax error highlighting for this option is disabled ( statements in the Editor area are shown as syntactically correct).
Productivity tips
View a console history
In a console, right-click any area and select Local History | Show History.
Apply a code style in the editor
Right-click any area in the editor and select Reformat. Alternatively, press Ctrl+Alt+L.
View the file path of a query console
To see the details of a file, hover the cursor over the console tab.
Navigate to a console file from the Select In window
Press Alt+F1, select Files View and press Enter.
Rename a console file
Right-click a console tab, and select Rename File.
Open the Project tool window ( ) and navigate to . Select the console file, and press Shift+F6.