With this option, a Query Editor to access multiple databases from multiple hosts.
It also displays the currently accessed database. You can also selectively access a database from a different host that are currently connected to the CUBRID Manager. In the figures below, yellow highlighted sections mean the followings: the left one is displayed when it is accessed by DBA; the right one is displayed when no database is selected. The former makes you to check out which account is currently used; the latter allows you to select a database to connect when no database connection is made.
If you select a different database without stopping transactions in the currently accessed database, you are prompted whether to commit or rollback transactions in progress as below.
The edit function of the Query Editor is synchronized with [Edit] on the menu. The following table shows options available on the Query Editor's toolbar: Major options are provided with a shortcut key.
Option |
Icon |
Shortcut Key |
Description |
---|---|---|---|
Open |
|
|
Opens a text-based SQL and displays it in the query edit pane. |
Save |
|
|
Stores the contents of the query edit pane. |
Save As |
|
|
Stores the contents of the query edit pane in a different name. |
Run |
|
F5 |
Executes all the queries in the query edit pane. Alternatively, executes queries selected as a block. This icon is deactivated when the execution is unavailable ( |
Commit |
|
|
Keeps deactivated in autocommit mode ( |
Rollback |
|
|
Keeps deactivated in autocommit mode ( |
auto commit |
|
|
Automatically commits queries executed in the query edit pane. You can toggle the icon. When auto commit is on, the icon is displayed as |
Display query plan |
|
F6 |
Displays the execution plan of the selected query. For details, see Query Execution Plan. |
Undo |
|
Ctrl+Z |
Cancels the most recent edit action. |
Redo |
|
Ctrl+Y |
Re-executes the most recent edit action that is canceled by Undo. |
Find/Replace |
|
Ctrl+F |
Provides search and replace function that can be used in the query edit pane. |
Find next |
|
F3 |
Provides further search for items that are already searched once. |
Convert to comment |
|
Ctrl+/ |
Adds the comments to the selection area or to the line where the cursor is located in the query edit pane. Comment strings are inserted with a double dash (--). |
Delete comment string |
|
Ctrl+/ |
Deletes the comments from the selection area or from the line where the cursor is located in the query edit pane. |
Insert tab |
|
Tab |
Indents the selection area in the query edit pane. |
Delete tab |
|
Shift+Tab |
Un-indents the selection area in the query edit pane. |
Format SQL |
|
Ctrl+Shift+F |
Formats the selected SQL strings in the query edit pane. |
Get OID info |
|
|
A toggle button available on the toolbar in the query edit pane for [Get OID info], which can be found in the Query Editor options. That is, by selecting this button on the toolbar when [Get OID info], which can be found in the Query Editor options, is OFF, you can directly modify/delete data in the query results pane for subsequent queries. In this button is selected on the toolbar, however, this only applies to the corresponding Query Editor. The values of the Query Editor options for the corresponding database won't be changed. |
Set defined SQL parameter |
|
|
To specify a parameter whenever the statement is executed, write Prepared Statement, select the written statement, and click the icon. |
Quick Help |
|
Show the help about the selected text in the editor. | |
Show/Hide Query Result | ![]() |
Show or hide the query result pane. |