Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 | 

Query Edit Pane

In the query edit pane, you can enter and edit queries to manipulate the database. You can also use all functions available on the toolbar. The query edit pane provides functions such as automatic statement completion, editing via the pop-up menu and viewing schema information.

Shortcut Menu

If you right-click on the query edit pane, you can select Copy, Cut, Paste, Find/Replace, SQL Format and Show Schema Info. The editing function is synchronized with [Edit] of the menu.

manager_queryeditor_editor_context.png

Show Schema Info

If you select a table name and then execute [Show Schema Info], you can create a query while seeing the Query Editor view and the Schema Info view on the same window. Note that you can view the schema information only when executing Query Editor in the Explorer (toolbar not supported).

manager_queryeditor_editor_schema.png

Automatic Statement Completion

If you enter a CUBRID database keyword, CUBRID automatically finds and completes the statement, increasing usability and user accessibility.

manager_queryeditor_editor_auto.jpg

Executing Multiple Queries

Enter a semicolon at the end of the query statement to specify the end of one query and the start of the next. If there are multiple queries, they are executed sequentially. Each query creates a corresponding tab in the query results pane. If you execute multiple queries without separating them with semi-colons, only the first query is executed, with the rest ignored.

Execute Query Quickly

Press Ctrl+Enter will execute the sql where current cursor is.

Drag and Drop

If you drag and drop a table to retrieve from the host navigation tree into the query edit pane of the Query Editor, a SELECT query statement is created automatically.

And the columns of tables also support drag and drop to the query editor.

manager_queryeditor_editor_dragndrop.png

Cancel Query Function

A function that stops the currently running query. This can be divided into two functions.

  • When executing multiple queries : If you click the Stop button when multiple queries are being executed with the auto commit button enabled, queries processed before the stop operation are reflected normally, and the currently canceled query and following ones are not reflected. If the auto commit button is not enabled, no executed queries are reflected.
  • When executing a long transaction : If you click the Stop button when executing a long transaction, a query stop command is delivered to CUBRID Manager > JDBC > Broker > Server, and the query finally stops in the database server the query is actually canceled. For Windows, this function is supported in CUBRID 2008 R2.2 or later.
  • manager_queryeditor_editor_stop.jpg