Executing SQL Statements

Last modified: October 23, 2019

How to Run Execution

Entire Script

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

• Click the Execute button on the Devart - SQL toolbar.

• On the dbForge SQL menu, select the Execute command.

Selected Block of Text

To execute an arbitrary text block from the SQL editor, you need to perform the following steps:

1. Select the text block using the mouse or keyboard.

2. Do one of the next steps:

• Run the Execute command in one of the above ways
• Select Execute Selection on the shortcut menu in the SQL editor

Note

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

Current Statement

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

• Click the Execute Current Statement button on the Devart - SQL toolbar.

• Right-click a required statement, and select the Execute Current Statement command on the shortcut menu.

How to Stop Execution

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

To stop SQL execution, click the Stop Execution button on the Devart - SQL toolbar.