|
Close a menu or dialog box, canceling the action |
||
|
Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window |
||
|
Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window |
||
|
Increase line indent |
||
|
Insert the number of spaces configured for the editor |
||
|
then UP arrow or DOWN arrow: Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane |
||
|
Moves to the next control on the page |
||
|
Display the grid on the design surface |
||
|
Open a detail window from a grid |
||
|
Insert a new line |
||
|
Help |
||
|
Copies entire selected row in grid |
||
|
Copy to the Clipboard |
||
|
Save the selected item |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Refresh |
||
or
|
|||
|
Change the name of the selected object |
||
|
Reverse the last editing action |
||
|
Paste from the Clipboard at the insertion point |
||
|
Select the entire current document |
||
|
Delete one character to the right of the cursor |
||
|
Find the next occurrence of the previous search text |
||
|
Display the Find dialog box |
||
|
Move the cursor left |
||
|
Move the cursor right |
||
|
Move the cursor up |
||
|
Move the selected control left in increments of 8 on the design surface |
||
|
Move the selected control right in increments of 8 on the design surface |
||
|
Move the selected control up in increments of 8 on the design surface |
||
|
Cut (delete the currently selected item and place it to the Clipboard) |
||
|
Move the selected control down in increments of 8 on the design surface |
||
|
Move the cursor down |
||
|
Display the New File dialog box to create a file |
||
|
Display the New File dialog box to create a new file |
||
|
Open a new query with current connection |
||
|
Display the Open File dialog box to open an existing file |
||
or
|
|||
|
Opens a new query editor window |
||
|
|
||
or
|
|||
|
Start incremental search. Type the characters to search for or press |
||
|
Run the query specified in the Query Designer |
||
|
Show or hide the query results pane |
||
|
Restore the previously undone edit |
||
|
Display the Properties Window |
||
|
Toggle between Object Explorer Details list view and Object Explorer Details property pane |
||
|
(in the Database Engine Query Editor) Move to the next tool window |
||
|
Move to the next pane of a split pane view of a single document |
||
|
Toggle between query and results pane |
||
|
Move to the next pane of a split pane view of a document |
||
|
Define filter |
||
|
Cycle through panels |
||
|
Break at function |
||
|
Toggle breakpoint |
||
|
Cuts all of the selected lines, or the current line if nothing is selected |
||
|
Move the cursor to the beginning of the line |
||
|
Display the Summary Window |
||
|
Apply filter |
||
Advertisement |
|||
|
When in the results pane, moves focus to the tool strip docked at the bottom of the designer |
||
|
Display the Go To Line dialog box |
||
|
Display Object Explorer |
||
|
Show all columns |
||
|
Cancels or stops the currently running query |
||
|
Output results in text format |
||
|
Swap the characters on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Delete one character to the left of the cursor |
||
|
Step into |
||
|
Make the selected text lower case |
||
|
Move the cursor to the end of the line |
||
|
Select the word containing the cursor, or the closest word |
||
|
Move the cursor down one screen |
||
|
Move the cursor up one screen |
||
|
Step over |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
Display the Replace dialog box |
||
|
Save all |
||
|
(on the numeric keypad) Collapse tree nodes |
||
|
Expand or collapse all panes |
||
|
Displays the definition for the selected symbol |
||
|
Insert a blank line above the cursor |
||
|
Move selected lines to the left on tab stop |
||
|
Decrease line indent |
||
|
Moves to the previous control on the page |
||
|
Displays the diagram pane of the Query Designer |
||
|
Run the sp_who system stored procedure |
||
|
Copy the result grid and headers to the clipboard |
||
|
Copy cell |
||
|
Filter the monitor display |
||
|
List members |
||
|
Expand or collapse all panes |
||
|
Moves the cursor one word to the left |
||
|
Moves the cursor one word to the right |
||
|
Display the IDE navigator with the first document window selected |
||
|
Run the sp_lock system stored procedure |
||
|
Displays the criteria pane of the Query Designer |
||
|
Display the Add New Item dialog box to add a new file to the current project |
||
|
Restore the previously undone edit |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Refresh local cache |
||
|
Complete word |
||
|
Scroll text down one line |
||
|
Scroll the tree control down in the window |
||
|
Scroll text up one line |
||
|
Scroll the tree control up in the window |
||
|
Change the selected text to lowercase |
||
|
Cuts all of the selected lines, or the current line if nothing is selected |
||
|
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item |
||
|
Expand or collapse selected pane |
||
|
Go back to the previous document or window in the navigation history |
||
|
Insert a new line |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Set next statement |
||
|
Move to the SQL Server Management Studio menu bar |
||
|
Displays the SQL pane of the Query Designer |
||
|
Display the previous page in the viewing history. Available only in the Web browser window |
||
|
Back, display the previous page in the viewing history |
||
|
Display the New Project dialog box to create a new project |
||
or
|
|||
|
Output results in a grid |
||
|
Forward, display the next page in the viewing history |
||
|
Complete word |
||
|
Display the next page in the viewing history. Available only in the Web browser window |
||
|
Output results to a file |
||
|
Specify values for template parameters |
||
|
Transpose the words on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Moves the cursor one character to the left and extends the selection |
||
|
Reduces the width of the selected control in increments of 8 |
||
|
Display the Open File dialog box to open an existing file |
||
|
Moves the cursor one character to the right and extends the selection |
||
|
Increases the width of the selected control in increments of 8 |
||
|
Move the cursor to the beginning of the document |
||
|
Display the Navigate To dialog box. |
||
|
Expand or collapse selected pane |
||
|
Reverse incremental search so it starts at the bottom of the file and searches to the top |
||
|
Displays the results pane of the Query Designer |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Toggle between insert mode and overtype mode |
||
|
Move the cursor to the end of the document |
||
|
Select text up line by line starting from the cursor |
What is your favorite SQL Server Management Studio (SSMS) hotkey? Do you have any useful tips for it? Let other users know below.
1108032
498772
411518
366987
307454
277921
26 minutes ago
4 hours ago
23 hours ago
24 hours ago Updated!
2 days ago
3 days ago
Latest articles