Executing SQL Statements

How to Run Execution

Entire Script

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

  • Press F5.

  • On the SQL toolbar, click Execute.

  • On the main menu, click SQL and then click Execute.

Selected Block of Text

To execute arbitrary block of text from SQL editor:

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

  2. Do one of the next steps:

  • Run the Execute command using one of the ways in the Entire Script topic

-or-

  • Press Ctrl+F8.

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

  • On the main menu, click SQL and then click Execute Selection.

Note

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

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:

  • on SQL toolbar, click Stop Execution.

  • On the main menu, open the SQL menu and then click Stop Execution.

  • On the SQL toolbar, click Stop Execution.