The following table lists the shortcut keys specific to the Query window.
- Ctrl+/ toggle comment
- Ctrl+] Move to Matching Brace
- Ctrl+Shift+] Select Block
You may, however, assign your own shortcuts through the Keyboard button using the Customize dialog.
Shortcut Key | Description |
---|---|
Ctrl+/ |
Turns the selected text (or the current line, if no text is selected) into a comment, or turns the current comment into text. See before this table for more information. See note about changing this shortcut. |
Ctrl+B | Adds or removes the bookmark at the current line. |
Ctrl+D | Removes all bookmarks. |
Ctrl+E | Replays the most recently played macro. If no macro has been played then it opens the Keyboard Macros dialog to allow selection of the macro to be played. |
Ctrl+I | Indents the current, or selected, lines. |
Ctrl+Shift+I | Un-indents the current, or selected, lines. |
Ctrl+K | Expand or Collapse the current block of text. |
Ctrl+L | Converts selected text to lowercase. |
Ctrl+M | Records a macro. |
Ctrl+R |
Sets the repeat count. When you set a repeat count, the next keyboard command you execute is repeated that number of times. This is most useful for playing your macros, or for such things as “Extend to end of word” (CTRL+Shift+→).
|
Ctrl+T | Deletes the current query in the Query window. |
Ctrl+U | Converts the selected text to uppercase. |
Ctrl+W | Display or Hide white space characters. |
Ctrl+F2 | Moves the cursor to the next bookmarked line. |
Ctrl+] |
Moves the cursor to the matching brace (for example, from “(“ to “)”, or from “Begin” to “End”). See note about changing this shortcut. |
Ctrl+Space | Displays suggested name list, if appropriate. |
Ctrl+Shift+Space |
Adds the last table/view/alias name in a FROM clause to the Active List. This key combination should only be used when the cursor immediately follows that object or alias name.
|
Alt+Down arrow | Moves the current line down. |
Alt+Up arrow | Moves the current line up. |
Alt+Insert | Inserts a new line above the current line. |
Alt+Delete | Deletes the current line. |
Alt+Ctrl+Insert | Duplicate the current line. |
Ctrl+Shift+] |
Selects a logical block (when a brace match is highlighted). See note about changing this shortcut. |
Ctrl+Shift+Del | Deletes all blank lines within the selected text. |
Tab | Indent lines (only if text is selected). |
Shift+Tab | Unindent lines (only if text is selected). |
Shift+F2 | Go to the previous bookmark. |
Shift+Up arrow | Extend the selection up one line. |
Shift+Down arrow | Extend the selection down one line. |
Shift+Alt+arrow | Extend column selection in direction of arrow (see Alt+Drag Mouse). |
← | Moves the cursor one character to the left. |
→ | Moves the cursor one character to the right. |
Home | Moves the cursor to the start of the current line. |
End | Moves the cursor to the end of the current line. |
PageDown | Moves down one page. |
PageUp | Moves up one page. |
Ctrl+← | Moves to the start of the current, or previous, word. |
Ctrl+→ | Moves to the start of the next word. |
Ctrl+Home | Moves to the start of the query. |
Ctrl+End | Moves to the end of the query. |
Shift+← | Extends the selection one character to the left. |
Shift+→ | Extends the selection one character to the right. |
Shift+Home | Extends the selection to the start of the current line. |
Shift+End | Extends the selection to the end of the current line. |
Shift+PageDown | Extends the selection down one page. |
Shift+PageUp | Extends the selection up one page. |
Ctrl+Shift+← | Extends the selection to the start of the current, or previous, word. |
Ctrl+Shift+→ | Extends the selection to the start of the next word. |
Ctrl+Shift+Home | Extends the selection to the start of the query. |
Ctrl+Shift+End | Extends the selection to the end of the query. |
Ctrl+Mouse Wheel | Zooms the active window in and out. |
Alt+Drag Mouse |
Select columns of text. Requires a fixed pitch font to be useful.
Anything you type while the block is selected replaces the selected text on ALL selected lines. You remain in this column mode until you use the mouse again, or press Esc, or the arrow keys. |