SQL Editor

The SQL Editor is the place to create, test and examine your statements. There are some additional features made for your easier life. Of course you can customize editor behavior in Preferences.

Important

Transaction handling. Transactions in the SQL scripts (in this editor) are under user control. There is no autocommit and automatic transaction starting. You can use PRAGMAs on your own of course.

It's strongly recommended not to mix transaction started in SQL Editor and in Data Viewer. You can get some ugly collisions then.

SQL editor

Run current statement F9 Ctrl+Return

The current statement is the SQL block under cursor or the text in editor selection.

Explain Plan F6

The EXPLAIN tool is used for the current statement.

Run Multiple Statements F5

Use this action when you need to run more statements in one batch.

If there is a selection in editor, all statements in this selection will be used. If there is no selection, all statements from cursor position will be used.

The "Start from cursor" feature is very useful when your script contains an error. You can continue after correction from the middle of file.

Create View

Create a view from the current statement. The Create View Dialog with the current statement will be shown.

New Document

Create a new empty document in the editor. User is asked for save if there are any unsaved changes.

Open Document

Open an existing file.

Save Document

Save the current file. If the document does not have file name, the Save As dialog is shown.

Save Document As

Save the current file with changed name.

Search in the document Ctrl+F

Open or close the Search panel in the bottom of the SQL Editor.