Query Specific Shortcut Keys - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Query Specific Shortcut Keys

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

 

Table 50: Query Specific Shortcut Keys 

Shortcut Keys

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

Ctrl+B

Adds or removes the bookmark at the current line

Ctrl+D

Removes all bookmarks

Ctrl+E

Displays the Play Macro dialog

Ctrl+I

Indents the current, or selected, line(s)

Ctrl+Shift+I

Un-Indents the current, or selected, line(s)

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.

Note: 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”)

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.

Note: 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)

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’ below)

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

Note: 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.