Execute SQL statements

Execute an 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.

Execute a selected block of text

To execute an 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 text block is selected in SQL editor, the application automatically chooses executing the selected SQL block over executing the entire document.

How to stop the 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 the main menu, open the SQL menu and then click Stop Execution.

  • On the SQL toolbar, click Stop Execution.