Executing SQL Statements

How to Run Execution

Entire Script

You can execute all SQL statements in current SQL document in one of the following ways:

  • Press <%EXECUTE_SHORTCUT%>.

  • Click the Execute button on the SQL toolbar.

  • Open the SQL menu in the main menu and select Execute command.

Selected Block of Text

To execute arbitrary block of text from SQL editor you need to do nothing special:

  1. Select block of text using mouse or key board.

  2. Do one of the next steps

  • Run Execute command in one of the above ways

or

  • Press <%EXECUTE_SELECTION_SHORTCUT%>.

  • Right click in SQL editor to open pop-up menu and select Execute Selection command.

Note

When a block of text is selected in SQL editor, program automatically chooses executing selected SQL block over entire document.

Current Statement

You can run SQL statement under the caret in one of the following ways:

  • Press <%EXECUTE_CURRENT_SHORTCUT%>.

  • Click Execute Current Statement button on SQL toolbar.

  • Open the SQL menu in the main menu and select Execute Current Statement command.

  • Right click in SQL editor to open pop-up menu and select Execute Current Statement command.

How to Stop Execution

All queries and scripts run asynchronously. After starting execution you can work with other SQL documents, execute different queries and so on. After the end of execution a message will appear in the Output window.

You can stop SQL execution in one of the following ways:

  • Click Stop Execution button on SQL toolbar.

  • Open the SQL menu in the main menu and select Stop Execution command.

  • Click Stop Execution button on SQL toolbar.

  • Open the SQL menu in the main menu and select Stop Execution command.