Versions available for this page: CUBRID 8.4.0 | CUBRID 8.4.1 |
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.
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.
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).
If you enter a CUBRID database keyword, CUBRID automatically finds and completes the statement, increasing usability and user accessibility.
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.
Press Ctrl+Enter will execute the sql where current cursor is.
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.
A function that stops the currently running query. This can be divided into two functions.