Create a New SQL Script File: Creates a new SQL Script tab where SQL code can be entered.

Open a SQL Script File: Loads a saved SQL script to be ready for execution. The script is displayed in the SQL Query area.

Save SQL Script to File: Saves the currently loaded SQL script to a file specified by the user.

Save SQL to Snippets List: Enables SQL code snippets to be given a name. They will appear in the SQL Snippets palette in the SQL Editor sidebar.

Execute SQL Script in Connected Server: Executes the currently loaded SQL script. Results are displayed in one or more Results tabs.

Execute Current SQL Statement in Connected Server: Executes the current SQL statement. Results are displayed in one or more Results tabs.

Explain (All or Selection): Explains SQL statements, or the currently selected one.

Stop the query being executed: Halts execution of the currently executing SQL script. This restarts the connection to the database server.

Toggle whether execution of SQL script should continue after failed statements: If the red “breakpoint” circle is displayed, the script terminates on a statement that fails. If the button is depressed so that the green arrow is displayed, execution continues past the failed code, possibly generating additional result sets. In either case, any error generated from attempting to execute the faulty statement is recorded in the Output tabsheet.

Commit: Commits a transaction.

Rollback: Rolls back a transaction.

Toggle Auto-Commit Mode: If selected, transactions are automatically committed.

Reconnect to DBMS: Re-establishes the database connection.

Refresh state of database structures: Refreshes the view of Schemata, Tables, Views and Routines that appears in the Live Overview Schema tabsheet. For example, if an SQL script creates a new table, it will not appear in the Overview tab until the refresh toolbar button is clicked.

Toggle whether query result tabs should be kept between queries by default: Normally when a script is executed, results generated from previous executions of the script are lost, and the new results are displayed in the results tab. If this toggle button is pressed, so that the pin appears inserted, previous results are retained. Each execution of the script creates a new Results tab containing the result set.