 |
|
Keyboard shortcuts
| Connect to DB |
| Connect | F12 | Press F12 if you don't want to save connection as Profile. |
| Disconnect | Ctrl-F12 | Disconnect from DB. |
| Profiles dialog | Ctrl-P | Start Profiles dialog to Create, Edit or Delete profiles. |
| SQL Editor |
| Undo | Ctrl-Z | Undo changes (1000 steps). |
| Cut | Ctrl-X | Cut selection into the clipboard. |
| Copy | Ctrl-C | Copy selection into the clipboard. |
| Paste | Ctrl-V | Paste selection from the clipboard. |
| Clear All | Ctrl-Del | Clears both Command and Data windows. If SQL query was executed, it will be stored in SQL history. |
| Select All | Ctrl-A | Select all text in SQL Editor window. |
| Search | Ctrl-F | Search desired context in SQL Editor window. |
| Replace | Ctrl-H | Search desired context in SQL Editor window and replace it by another. |
| Search Again | F3 | Search again or replace the next context found. |
| Go to Line Number | Ctrl-G | Jump cursor to desired line number. |
| Insert Code Template | Ctrl-J | Open Command Insight listbox with most frequently used SQL commands for quick insert. |
| SQL script |
| Open SQL script file | Ctrl-O | Open Open SQL script dialog. |
| Save SQL Script file | Ctrl-S | Open Save SQL script dialog. |
| Execute | F9 | Execute SQL query immediately. If an error will occur, corresponding SQL query line will be highlighted. |
| Previous SQL | Alt-Left | For navigating within SQL history. Loads previous SQL query. |
| Next SQL | Alt-Right | For navigating within SQL history. Loads next SQL query. |
| SQL History | Alt-Home | Open SQL history to select desired SQL query directly. Note: only unique SQL queries are stored in SQL history. |
| Visual Query Builder | Ctrl-Alt-V | Start Visual Query Builder. |
| Table |
| Set Filter | Ctrl-Alt-F | Open Set filter dialog to set filter conditions. |
| Drop Filter | Ctrl-Alt-D | Drop filter immediately. |
| Quick filter | Ctrl-Alt-Q | Filter result set using current field value as filter expression. |
| Export Table Data | Ctrl-Alt-E | Open Export dialog. |
| Best fit | Ctrl-W | Fit columns width. |
|