SQL Editor

Overview

SQL Editor supports autocomplete, syntax highlight, statement execution, script execution, and execution plan for some databases.

Shortcuts

Shortcut	Description
Ctrl+Enter	Execute SQL statement
Ctrl+</kbd> or Ctrl+Shift+Enter	Execute SQL statement in new tab
Alt+X	Execute script
Shift+Ctrl+E	Show execution plan
Alt+T	Open SQL Editor in separate browser tab
Shift+Ctrl+F	Format script
Ctrl+Z or CMD+Z	Undo
Ctrl+Y or Ctrl+Shift+Z or Shift+CMD+Z or CMD+Y	Redo

Statement Execution

Place the cursor on the line with the statement or select part of the script to execute the statement. Click on the Run icon in the left toolbar or use the Ctrl+Enter shortcut. The result of the statement execution will be shown under the script editor area. Results will be grouped (Result - 1 <1>, Result - 1 <2>) if statement execution is finished with more than one result.

Script Execution

Click on the Script icon in the left toolbar or use the Alt+X shortcut to execute the script. The summary result will be shown in the Statistics tab, and results will be shown in separate Result tabs.

Auto and Manual commit

By default, all database connections in the SQL Editor operate in Auto-commit mode, meaning that changes are automatically committed after each SQL statement is executed. To gain precise control over your transactions, you may switch to Manual commit mode.

Switching to Manual commit

In Manual commit mode, you manually determine when to commit or rollback transactions. This mode is essential when batch operations need to be treated as a single unit or when you need to inspect changes before making them permanent.

Here is a table outlining the actions and their corresponding icons in Manual commit mode:

Action	Icon	Description
Switch to manual commit		Click to open a menu for manual transaction control. You will need to Commit or Rollback changes explicitly.
Commit		Click after executing SQL statements to save the changes to the database.
Rollback		Click to revert changes made by your SQL statements, undoing current transaction changes.
Switch to auto-commit		Click to return to Auto-commit mode, where changes are automatically committed.

Limitations of Rollback capabilities

In database management, not all commands support rollback operations. It is crucial to understand that Data Definition Language (DDL) commands—such as CREATE, DROP, or ALTER cannot be reversed with transactions for some databases. This means that once these commands are executed, they cannot be reversed even in manual commit mode.

Important: Always check the transaction support for the specific database you are working with to avoid irreversible operations.