Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Edit SQL > Editor Shortcut Keys

Editor Shortcut Keys

You can assign individual shortcut keys in Keyboard options. See Keyboard Options for more information. You can also customize Toad to use the shortcut keys of existing applications such as Toad for Oracle, SQL Navigator, or Query Analyzer in the Configuration Wizard (Tools | Configuration Wizard).

Caution! If you have some global access keys assigned, make sure that Toad shortcut keys do not coincide with them. When using such duplicating shortcut keys in Toad, the third party application commands, assigned globally, will be performed instead of ones assigned by Toad.

Tip: You can also use Auto-replace to specify words which can be used as shortcuts for entering phrases or statements. See Use Auto-Replace in the Editor for more information.

The following table describes the default shortcut keys in Toad.

Frequently Used Functions

Description

CTRL+N

Opens a new editor window

CTRL+PERIOD

Displays the code completion list

F9

Execute current statement

F5

Execute all statements, in order, one at a time

CTRL+K, CTRL+C

Comments the selected line

CTRL+K, CTRL+U

Uncomments the selected line

CTRL+J

Collapses all code regions

CTRL+M

Expands all code regions

ALT+PAUSE

Stops script execution

Bookmark

Description

CTRL+K, CTRL+K

Sets or removes a general bookmark

CTRL+SHIFT+0-9

Sets a numbered bookmark at the selected line

CTRL+0-9

Goes to the numbered bookmark

Case

Description

CTRL+SHIFT+L

Converts the selected text to lowercase

CTRL+SHIFT+U

Converts the selected text to uppercase

Clipboard

Description

CTRL+C

Copies the selected text to the clipboard

CTRL+X

Cuts the selected text for pasting in the clipboard

CTRL+V

Pastes text from the clipboard

Code Completion

Description

CTRL+PERIOD

Displays code completion list

ENTER

Selects an item and close the code completion list

CTRL+SPACE

Selects an item without closing the code completion list

CTRL+<right arrow>

Expands a node in the code completion list

CTRL+<left arrow>

Collapses a node in the code completion list

Comment

Description

CTRL+K, CTRL+C

Comments the selected line

CTRL+K, CTRL+U

Uncomments the selected line

Cursor

Description

HOME

Moves the cursor to the beginning of the line

CTRL+HOME

Moves the cursor to the beginning of the file

END

Moves the cursor to the end of the line

CTRL+END

Moves the cursor to the end of the file

Debugger

Description

SHIFT+F12

Step from cursor

F7

Step into

SHIFT+F7

Step out

F8

Step over

F11

Run to breakpoint

F12

Run to cursor

CTRL+B

Set breakpoint

CTRL+W

Add watch at cursor

Delete

Description

BACKSPACE

Deletes the selected text (if text is selected); otherwise, deletes the previous character

CTRL+BACKSPACE

Deletes text to the beginning of the previous word

CTRL+SHIFT+DELETE

Deletes the entire script

Find and Replace

Description

CTRL+F

Finds text

F3

Finds the next occurrence of text

SHIFT+F3

Finds the previous occurrence of text

CTRL+G

Goes to line number

CTRL+I

Performs an incremental search

CTRL+SHIFT+I

Performs a reverse incremental search

Indent

Description

TAB

Indents the selected line

SHIFT+TAB

Outdents the selected line

Macros

Description

CTRL+SHIFT+R

Starts/Stops recording a macro

CTRL+SHIFT+P

Plays the recorded macro

Miscellaneous

Description

F4

Invokes objects search

F4+SHIFT

Describes the object next to the cursor

F6

Toggles between the Editor and Data Grid

CTRL+D

Sends SQL to Query Builder

SHIFT+F8

Recalls the previous SQL statement

CTRL+á

Scrolls up the window.

CTRL+â

Scrolls down the window

<auto-replace token>+SPACE

Automatically replaces a misspelled word, inserts symbols, and expands text.

Note: You can set autoreplace in Tools | Options | Editor | Autoreplace.

CTRL+SPACE

Displays the Code Snippets folder browser

<code snippet shortcut name>+CTRL+SPACE

Inserts the code snippet template

CTRL+DELETE

Sets the column value for the current cell to Null in the data grid

  

Related Topics

About Editing SQL

Insert Code Snippets

About Debugging SQL

of