Toad for SQL Server 7.2 - Installation Guide

Install Toad Install Toad Silently Install Toad on Citrix Systems Upgrade Toad Upgrade Automation Scripts Files Migrated During Upgrades Integration between Toad and Microsoft SQL Server Management Studio

Create Connections

Understand Toad Connections Create SQL Server Connections

Troubleshoot Connections

Troubleshoot SQL Server Issues

Configure Version Control

About Version Control File Version Control Configure Version Control Manage Objects and Scripts under Version Control Troubleshoot Version Control

Configure SQL Server Debugging

Configure SQL Server Debugging Set Up Debugging

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
ALT+LMB	Hold Alt + left-click and drag to select vertical blocks of text
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+R	Show/hide Results pane
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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad for SQL Server 7.2 - Installation Guide

Editor Shortcut Keys