Skip navigation links
6.2.3 SQL Statements Panel »
Section Navigation      [Toggle]

6.2.2. Toolbar

The toolbar features ten buttons, as shown in the following screenshot:

Figure 6.6. SQL Editor - Toolbar

SQL Editor - Toolbar

From left to right these are:

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

  • Open a SQL Script File - Cicking this button allows any saved SQL script to be loaded ready for execution. The script will be displayed in the SQL Statements area.

  • Save SQL Script to File - Clicking this button allows the currently loaded SQL script to be saved to a file specified by the user.

  • Save SQL to Snippets List - SQL code snippets saved here can 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) - explain 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 will finish on a statement that fails. If the button is depressed so that the green arrow is displayed, then execution will continue past the failed code, possibly generating additional result sets. Any error generated from attempting to execute the faulty statement will be recorded in either case in the Output tabsheet.

  • Commit - commits a transaction.

  • Rollback - rolls back a transaction.

  • Toggle Auto-Commit Mode - if selected, transactions will automatically be 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 a SQL script creates a new table, it will not appear in the Overview tab until the refresh toolbar button is pressed.

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