Copy Result Set

Copies the table of results to the clipboard. You can only execute this command from the results pane.

Copy Result Set

(Tab Delimited)

Copies the table of results into a tab-delimited format that can be pasted into a spreadsheet.

Clear

Removes the contents of the text pane or results pane, depending on the pane from which you execute the command.

Execute

Executes the SQL statement in the text area, or executes the SQL statement that the user has selected in the text area.

Prepare

Parses the SQL statement in the text pane.

Query Design Center validates the syntax without attempting to execute the query. The results of a successful validation appear in the results pane along with item descriptions. If the syntax is not valid, an error message provides a description of the error.

Commit

Commits the current transaction when in manual commit mode.

Abort

Aborts the current transaction when in manual commit mode.

Savepoint

Saves a named savepoint when in manual commit mode.

Rollback to savepoint

Rolls back the current transaction to a selected savepoint when in manual commit mode.

Open Query

Enables you to place the contents of a saved query into the text pane.

Save Query As

Saves the contents of the text pane to a file.

Save Result Set As

Saves the results of an executed query to a text file.

Save Permissions As

Converts the results of an executed LIST PERMISSIONS query to GRANT syntax notation. The GRANT syntax is saved to a text file.

View Resources

Displays the Resources window.