SQL Results View

SQL Results view displays the results of executing SQL statements, running procedural objects, and creating database objects.

SQL Results view appears in the Database Development perspective and consists of a history frame and a details frame. The history frame displays the execution history for past queries. The details frame displays the status and results of the last execution.

Table 1. SQL Results history
Field	Description
History filter	Type a query expression in the text field atop the SQL Results history pane to filter the results according to operations matching the expression.
Status	Displays whether the operation failed, succeeded, terminated, or is still running.
Operation	Displays the SQL statement that was executed.
Date	Displays the current date and time when the operation failed, successfully executed, terminated, or reached a breakpoint.
Connection Profile	Displays the connection profile on which the corresponding operation was run.

To save SQL results, right-click in the history panel, and choose Save History from the context menu.

When you execute multiple queries in a SQL file containing a delimiter (such as go) using the Execute All or Executed Selected Text context-menu option in SQL Editor, the results are grouped in a tree structure in the SQL Results view. The root node is a top-level result history. Expand this node in the SQL Results view to see the results for each individual SQL statement.

There are two modes for the details frame, single-tab and multi-tab:

In single-tab mode, all results and messages appear in the same column, with messages and status at the end.
In multi-tab mode, each result and message is in a separate tab.

Table 2. SQL Results details
Field	Description
Status	Shows the status of running the procedural object or selected text
Parameters	Displays parameter names, datatypes, values, and type (input, return, and so on)
Result n	Displays results for a SQL query
Message n	Contains messages from the database server, such as the output of a SQL print statement

Use the drop-down menu to filter history results and set preferences for the SQL Results view and export format.

Table 3. SQL Results buttons
Icon	Name	Action
	Terminate Result	Terminate a long-running instance.
	Remove Result	Remove the status, result sets, and messages of a selected SQL result instance.
	Remove All Finished Results	Remove all results for completed statements from the SQL Results view.
	Display the Result in Text Mode	Toggle between text mode and grid mode.
	Display the Result in Single Tab	Toggle between single-tab and multitab display.
	Filter Results	Filter the current results.