Executing SQL Statements

Last modified: June 30, 2021

How to Run Execution

To execute the entire script, click the Execute button on the Devart-SQL toolbar.

Alternatively, go to the Extensions menu on the main toolbar, point to dbForge SQL, and then click Execute.

To execute an arbitrary text block:

Select the text block using the mouse or keyboard.
Run the Execute command as when executing the entire script. Alternatively, select Execute Selection on the shortcut menu of SQL Editor.

To execute current statement, click the Execute Current Statement button on the Devart-SQL toolbar.

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

To execute script to the current position of the cursor:

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

The query execution results can be represented in two ways - in text and in grid formats.

To represent results as text, click Results as Text on the Devart-SQL toolbar before query execution.

To represent results as grid, click Results as Grid on the Devart-SQL toolbar before query execution.

Was this page helpful?

Yes