A Query tab is displayed in the Workspace whenever you query a connection or database table, or display data on a table, as shown in the following screenshot:
It is divided into parts:
- The editor is where you enter queries to be run on the database.
- The results table is where the results of the last run query are shown.
The tool bar above the editor contains the following items:
Icon | Description |
---|---|
Click to Insert stored SQL query. You can select a stored query from the repository to be inserted at the cursor. Refer to Managing Stored Queries for details. | |
Click to Store SQL query. You can save the currently selected text, or the contents of the query pane if no text is selected, as a stored query in the repository. Refer to Managing Stored Queries for details. | |
Click to Cut the currently selected text from the editor pane and places it on the system clipboard. | |
Click to Copy and place the currently selected text in the editor pane on the system clipboard. | |
Click to Paste the current contents of the system clipboard into the editor pane. | |
Click to display a dialog to print the current contents of the results table.
| |
Click to Execute the current contents of the editor, as separate SQL queries on the current database. note
|