SQL Editor Toolbar Options

From RapidSQL
Jump to: navigation, search

Go Up to SQL Editor Windows Basics

The SQL Editor toolbar is displayed above the editing window.

at171786.jpg

The table below describes the options of the ISQL Editor toolbar:

Option Description

Lock - Unlock Connection

Lets you lock an ISQL Window to a specific datasource connection or unlock a currently locked window. For details, see Locking a SQL Editor Window to a Datasource.

Execute

Executes the script.

Execute Statement

Execute the statement at the cursor. For more information, see Executing the Current Statement.

Step Execute

Initiates step execution of the script. For more information, see Step Executing a Script.

Schedule

Opens a dialog that lets you schedule an SQL job. For more information, see Scheduling.

SQL Begin Transaction

Toggles the Begin Transaction status on and off.

SQL Rollback

Performs a rollback on the current transaction.

SQL Commit

Commits the current transaction.

Debug

Opens the IDERA SQL Debugger. For more information, see IDERA SQL Debugger.

Preprocess

Lets you set a preprocessing state for execution of the script. If you select Pre-process Only, subsequent use of the Execute button will result in the script being preprocessed without being executed. The script opens n a new editor window with all #define and #include substitutions made. If you select Pre-process and Execute, all #include and #define directives are carried out and the script is executed. No new editor window opens. For more information, see SQL Preprocessing: #define and #include.

Script Execution Facility

Provides a shortcut to opening the Script Execution Facility. For more information, see Script/File Execution Facilities.

Query Plan

Activates and deactivates Query Plan mode. For more information, see Using the Query Plan Facility.

Query Options

Provides a shortcut to opening the Query Options dialog. For more information, see Using the Query Plan Facility.

Format

Transforms spaghetti-style written SQL code into an easier read format.

Syntax Check

Initiates a syntax check. This is only necessary if SQL parsing is disabled and automatic syntax checking is therefore disabled. For more information, see Syntax Checking.

Errors

Toggles the Errors pane. For more information, see Toggling Display of the Error Pane.

Personal tools