Executing SQL Statements

How to Run Execution

Entire Script

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

Alternatively, on the SQL menu, select Execute or press F5.

Selected Block of Text

To execute an arbitrary text block:

  1. Select the text of the code you want to execute.

  2. On the SQL toolbar, click Execute.

    -or-

    On the shortcut menu of SQL Editor, select Execute Selection or press Ctrl+F8.

    -or-

    On the SQL menu, click Execute Selection.

Current Statement

To execute the current statement, on the SQL menu, click Execute Current Statement.

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

Execute to Cursor

To execute script to the current position of the cursor:

  1. Move the cursor to the required position.
  2. On the shortcut menu, click Execute to Cursor or press Ctrl+Shift+F10.

How to Stop Execution

To stop SQL execution, on the SQL menu, click Stop Execution.

Representing Query Execution Results

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

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

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