16.20 - Query-Specific Shortcut Keys - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

The following table lists the shortcut keys specific to the Query window.

The following shortcuts may not work on some keyboards:
  • 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.