Keyboard Shortcuts
The default keymap is provided below. For macOS, use Cmd instead of Ctrl.
| Keycode | Action |
|---|---|
| Ctrl+A | Select all |
| Ctrl+Home | Navigate to the beginning of the document |
| Ctrl+Left | Navigate to the beginning of the line |
| Ctrl+Backspace | Delete to the beginning of the line |
| Ctrl+F | Find |
| Ctrl+G | Find next |
| Ctrl+U | Undo selection |
| Ctrl+Alt+F | Search and replace |
| Alt+F | Move one word to the right |
| Ctrl+V | Page down |
| Alt+D | Delete one word to the right |
| Ctrl+Space | Autocomplete |
| Tab | Increase indentation |
| Shift+Tab | Decrease indentation |
| Esc | Exit full-screen mode |
| Ctrl+S | Save to a local file |
| Ctrl+E | Execute SQL |
| Ctrl+M | Insert myDBR command (Sublime Text: Ctrl+Alt+M) |
Macros
Macros provide shorthand for common SQL structures. The following are defined by default:
| Keycode | Action |
|---|---|
| Ctrl+Alt+S | SELECT clause |
| Ctrl+I | IF clause |
| Ctrl+Alt+I | IF-ELSE clause |
| Ctrl+Alt+W | WHILE loop |
Autocomplete for Table Columns
The SQL editor provides autocomplete functionality for table and view columns. To enable this, select the databases you wish to include in Editor Preferences.
To use autocomplete, first define your FROM clause; then, use either the table name or its alias in the SELECT statement to trigger column suggestions.
