Editor Keyboard Shortcuts
Load / Save
Ctrl + N | New Script |
Ctrl + O | Open file |
Ctrl + S | Save active script |
Ctrl + Shift + S | Save active script with different name |
Ctrl + W | Close active script tab |
Ctrl + Shift + W | Close active Result tab |
Cursor Movement
Left | Move cursor one character left |
Right | Move cursor one character right |
Up | Move cursor one line up |
Down | Move cursor one line down |
Ctrl + Up | Scroll screen up |
Ctrl + Down | Scroll screen down |
Ctrl + Right | Move cursor one word right |
Ctrl + Left | Move cursor one word left |
End | Move to end of line |
Ctrl + End | Move to end of last line in file |
Home | Move to beginning of line |
Ctrl + Home | Move to beginning of file |
Ctrl + G | Go To Line |
Edit
Ctrl + Y | Delete current line |
Ctrl + Shift + Delete | Delete all |
Ctrl + Delete | Delete to start of word to the right |
Ctrl + Backspace | Delete to start of word to the left |
Insert | Switch between overwrite and insert mode |
Ctrl + C | Copy to Clipboard |
Ctrl + V | Paste from Clipboard formatted as SQL |
Ctrl + Shift + V | Paste from Clipboard Excel style |
Alt + Shift + V | Paste as column block |
Ctrl + Alt + V | Paste as column block (fill) |
Ctrl + X | Cut to Clipboard |
Ctrl + Z, Alt + Back | Undo |
Shift + Tab | Indent to the left |
Ctrl + Shift + C | Comment selection out |
Ctrl + Shift + R | Un comment selection |
Ctrl + Shift + U | Convert selection to upper case |
Ctrl + Shift + L | Convert selection to lower case |
Ctrl + Shift + M | Replace template parameters |
Ctrl + Shift + Up | Move current line up |
Ctrl + Shift + Down | Move current line down |
Selection
Ctrl + A | Select all |
Alt + Left Mouse Button | Start column (block) selection |
Alt + C | Set block selection on. Use Shift + Arrow keys to extend selection |
Shift + Left Mouse Button | Extend selection to click point |
Ctrl + B | Select SQL block starting from current position |
Ctrl + Shift + B | Select current block delimited by empty lines |
Shift +Left | Extend selection to the Left |
Shift + Right | Extend selection to the right |
Shift + Up | Extend selection one line up |
Shift + Down | Extend selection one line down |
Shift + Home | Extend selection to the beginning |
Shift + End | Extend selection to the end |
Shift + Page Down | Extend selection one page down |
Shift + Page Up | Extend selection one page up |
Ctrl + Shift + Home | Extend selection from current position to the beginning of script |
Ctrl + Shift + End | Extend selection from current position to the end of script |
Ctrl + Shift + Left | Extend selection to the beginning of current word |
Ctrl + Shift + Right | Extend selection to the end of current word |
Ctrl + M | Highlight all words like the one under the cursor |
Find / Replace / Diff
Ctrl + F | Show Find dialog |
Ctrl + H | Show Replace dialog |
F6 | Quick Find |
F3 | Find next |
Shift + F3 | Find previous |
Ctrl + Shift + Q | Quick Diff Script |
Ctrl + Shfit + D | Quick Diff Result Set |
Query / SQL
Ctrl + E, F5 | Execute SQL statement |
Ctrl + Shift + E | Execute SQL statement. Results in new window |
Ctrl + Shift + F5 | Execute SQL statement. Results in new window |
Ctrl + Enter | Execute SQL statement on current line |
Shift + Enter | Execute currently outlined SQL statement if any |
Ctrl + F5 | Parse SQL statement |
Ctrl + K | Execute last Result Grid SQL statement |
Ctrl + J | Format selected SQL |
Alt + F1 | Object Properties under cursor |
Alt + F2 | Script object under cursor to new window |
Alt + F3 | Find object under cusrsor in Object View |
F4 | Refresh Object View |
F7 | List Tables |
F8 | List User Procedures and Functions |
F9 | List System Procedures and Functions |
F12 | Begin Transaction |
Ctrl + F12 | Commit Transaction |
Ctrl + Shift + F12 | Rollback Transaction |
Bookmarks
Ctrl + F2 | Toggle bookmark |
F2 | Go to next bookmark |
Shift + F2 | Go to previous bookmark |
Ctrl + Shift + F2 | Clear all bookmarks |
Miscellaneous
Ctrl + Page Down | Next Script Window |
Ctrl + Page Up | Previous Script Window |
Ctrl + Shift + Page Down | Next Connection Window |
Ctrl + Shift + Page Up | Previous Connection Window |
Ctrl + 1 | Switch focus between Editor and Results |
Ctrl + 2 | Switch focus between Editor and Object List |
Ctrl + 3 | Set focus to Script Editor |
F11 | Maximize Editor windox |
Ctrl + F11 | Maximize Results window |
Shift + F11 | Toggle Object View |