Input pane
The Input pane opens as an editor tab. Use this pane to type, edit, and run SQL commands on data sources. For each data source RubyMine opens a separate Input pane. For your convenience, the common console toolbar icons are also available from the Input pane.
| Item | Shortcut | Description |
|---|---|---|
| Ctrl+EnterCtrl+Enter | Click this button to run the command at the caret or all the selected consecutive commands. |
| Browse history Ctrl+Alt+ECtrl+Alt+E | Click this button to show the list of commands, executed in the console. You can select the desired commands, and place them to the Input pane. |
| Properties Ctrl+Alt+EnterCtrl+Alt+Enter | Click this button to open the Database Console Properties dialog box, where you can specify the SQL dialect to use and customize the console behaviour. |
| Close Ctrl+Shift+F4Ctrl+Shift+F4 | Click this button to close the current instance of the Database console. |
| Layout | Click this button to choose the desired layout of the toolbars from the pop-up menu. The available options are:
|
Result pane
Use this pane to view the result of executing queries as well as to add, remove, and update records in the queried table.
| Item | Shortcut | Description |
|---|---|---|
|
| Ctrl+EnterCtrl+Enter | Click this button to run the command at the caret or all the selected consecutive commands. |
|
| Browse history Ctrl+Alt+ECtrl+Alt+E | Click this button to show the list of commands, executed in the console. You can select the desired commands, and place them to the Input pane. |
|
| Properties Ctrl+Alt+EnterCtrl+Alt+Enter | Click this button to open the Database Console Properties dialog box, where you can specify the SQL dialect to use and customize the console behaviour. |
|
| Close Ctrl+Shift+F4Ctrl+Shift+F4 | Click this button to close the current instance of the Database console. |
| First Page Last Page | Click this button to switch to the page with the first/last set of results. |
| Previous Page Next Page Ctrl+DownCtrl+DownCtrl+UpCtrl+Up | Click this button to switch to the page with the previous/next set of results. |
|
Note The number of items to be shown in a result set is configured in the Database Console Properties dialog. | ||
| Reload Page Ctrl+RCtrl+R | Click this button to refresh the current page after editing or resorting the table data. |
| Add New Row Alt+InsertAlt+Insert | Click this button to have a new record added to the queried table. |
| Delete Selected Rows Ctrl+YCtrl+Y | Click this button to remove the selected rows from the queried table. |
| Copy Query Ctrl+Alt+Shift+CCtrl+Alt+Shift+C | Click this button to save the query that produced the current result. The SQL command is stored in the clipboard. |
| Copy Ctrl+C; Ctrl+InsertCtrl+C; Ctrl+Insert | Click this button to copy the values from the current result to the clipboard. |
Output pane
This pane displays information on SQL command execution. This information includes:
- Time stamp of the executed command.
- Number of affected rows.
- Duration in milliseconds. If the command execution involves processing the data received from the data source, the execution time is shown as x/y ms, where x is the time taken to receive the data, and y is the total time of generating the query result which includes both receiving and processing the data.
- Error messages.
| Item | Description |
|---|---|
| Clear All | Choose this option to have all the messages removed from the pane. |
| Copy Content | Choose this option to have RubyMine copy all the displayed messages to the clipboard. |
| Copy Selected Content | Choose this option to have RubyMine copy the selected messages to the clipboard. |
| Compare with Clipboard | Choose this option to open the Differences Viewer an compare the contents of the clipboard with the entire contents of the Output pane or with a specific selected message. |
| Item | Shortcut | Description |
|---|---|---|
|
| Ctrl+EnterCtrl+Enter | Click this button to run the command at the caret or all the selected consecutive commands. |
|
| Browse history Ctrl+Alt+ECtrl+Alt+E | Click this button to show the list of commands, executed in the console. You can select the desired commands, and place them to the Input pane. |
|
| Properties Ctrl+Alt+EnterCtrl+Alt+Enter | Click this button to open the Database Console Properties dialog box, where you can specify the SQL dialect to use and customize the console behaviour. |
|
| Close Ctrl+Shift+F4Ctrl+Shift+F4 | Click this button to close the current instance of the Database console. |
Parameters pane
| Item | Description |
|---|---|
| Parameter | This read-only field displays the names of parameters detected in the current SQL statement. |
| Value | In this text box, type the value to substitute for the parameter when the statement will be executed. |
Context menu of a tab
| Context menu command | Description | Available in |
|---|---|---|
| Detach | Choose this command to detach the selected view. This enables you to move the detached pane to any desired location. | All panes |
|
Note The Output and the Result panes can be detached only together. | ||
| Close | Choose this command to close the current tab. | Result pane |
| Focus on Startup | If this option is selected, the current pane gets the focus on launching the Database console. | All panes |
|
Select Next Tab/ Select Previous Tab | Use these commands to switch the focus between tabs within the Result pane or between the Output and the Result panes. |
Output pane Result pane |
