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:
REPLACE WITH THIS IMAGE: Images/Getting_Started/querytab.png
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 |
---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/open_sql.png |
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. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/saveicon.png |
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. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/cutquery.png |
Click to Cut the currently selected text from the editor pane and places it on the system clipboard. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/copyqueryicon.png |
Click to Copy and place the currently selected text in the editor pane on the system clipboard. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/paste_query.png |
Click to Paste the current contents of the system clipboard into the editor pane. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/printquery.png |
Click to display a dialog to print the current contents of the results table.
|
REPLACE WITH THIS IMAGE: Images/Common_Icons/executequery.png |
Click to Execute the current contents of the editor, as separate SQL queries on the current database. |
Note |
|
|
|