Keyboard shortcuts
General
| Shortcut | Action |
|---|---|
| F1 | View info about database. |
| F6 | View find. |
| F11 | View database objects. |
| F12 | View SQL editor. |
| Alt+F4 | Close the application. |
Database objects
| Shortcut | Action |
|---|---|
| Ctrl+F | Find. |
| F3 | Find the next matching text. |
| Shift+F3 | Find the previous matching text. |
| F5 | Refresh. |
Table data
| Shortcut | Action |
|---|---|
| Ins | Insert a record. |
| Ctrl+Del | Delete the record. |
| F5 | Refresh. |
| Ctrl+X | Cut. |
| Ctrl+C | Copy. |
| Ctrl+V | Paste. |
| Ctrl+Backspace | Set to null. |
| Alt+Backspace | Set to default. |
| Ctrl+G | Set to GUID. |
| Ctrl+J | Jump to column. |
Document, source, data pump and compare
| Shortcut | Action |
|---|---|
| Ctrl+S | Save as. |
| F5 | Refresh. In compare: compare databases. |
SQL editor
File and run
| Shortcut | Action |
|---|---|
| Ctrl+Enter | Run. The selection is executed if there is one, otherwise the whole text. |
| Ctrl+H | SQL history. |
| Ctrl+Shift+L | Add to SQL statement list. |
| Ctrl+N | Create a new file. |
| Ctrl+O | Open an existing file. |
| Ctrl+S | Save the active file. |
| Ctrl+F4 | Close the active file. |
| Ctrl+Shift+F4 | Close all other files. |
| Ctrl+Tab | Next page. |
| Ctrl+Shift+Tab | Previous page. |
| Ctrl+P | Print. |
Edit
| Shortcut | Action |
|---|---|
| Ctrl+Z | Undo. |
| Ctrl+Shift+Z | Redo. |
| Ctrl+X | Cut. |
| Ctrl+C | Copy. |
| Ctrl+V | Paste. |
| Ctrl+A | Select all. |
| Ctrl+Shift+C | Clear. |
| Ctrl+Shift+I | Increase indent. |
| Ctrl+Shift+U | Decrease indent. |
| Ctrl+Shift+A | Sort ascending. |
| Ctrl+Shift+D | Sort descending. |
| Ctrl+U | Upper case. |
| Ctrl+L | Lower case. |
| Ctrl+Shift+G | Insert GUID. |
| Ctrl+Y | Delete line. |
| Ctrl+Shift+T | Delete beginning of line. |
| Ctrl+Shift+Y | Delete end of line. |
| Ctrl+W | Delete word. |
| Ctrl+Backspace | Delete word backward. |
| Ctrl+Del | Delete word forward. |
Search
| Shortcut | Action |
|---|---|
| Ctrl+F | Find. |
| F3 | Find the next matching text. |
| Shift+F3 | Find the previous matching text. |
| Alt+Enter | Find all matching texts. |
| Ctrl+R | Replace. |
| Ctrl+Shift+R | Replace next. |
| Ctrl+Alt+Enter | Replace all. |
Bookmarks
| Shortcut | Action |
|---|---|
| Ctrl+F2 | Toggle bookmark. |
| Ctrl+Shift+1…9 | Toggle bookmark 1…9. |
| Ctrl+B | Toggle bookmark n. |
| Ctrl+1…9 | Go to bookmark 1…9. |
| F2 | Go to next bookmark. |
| Shift+F2 | Go to previous bookmark. |
| Ctrl+Shift+B | Add caret bookmark. |
| Shift+Esc | Swap caret bookmark. |
| Esc | Return to caret bookmark. |
| Ctrl+Alt+Backspace | Go to last edit position. |
Dialogs
| Shortcut | Dialog | Action |
|---|---|---|
| Ctrl+A | Connections | Select all. |
| Ctrl+D | Connections | Unselect all. |
| Ctrl+N | Query parameters | Set to null. |
| Ctrl+E | Query parameters | Set to empty string. |
| Ctrl+F | BLOB editor | Find. |
| F3 | BLOB editor | Find the next matching text. |
| Shift+F3 | BLOB editor | Find the previous matching text. |