|
Display the New File dialog box to create a file |
||
|
Close a menu or dialog box, canceling the action |
||
|
Close the current MDI child window |
||
|
Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window |
||
|
Moves the insertion point to the drop-down bar located at the top of the code editor when the editor is in Code view or Server Code view |
||
|
(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 |
||
|
Display Object Explorer |
||
|
Display the Summary Window |
||
|
Display the Properties Window |
||
|
Toggle between Object Explorer Details list view and Object Explorer Details property pane |
||
|
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 |
||
|
Move the cursor left |
||
|
Move the cursor right |
||
|
Move the cursor up |
||
|
Move the cursor down |
||
|
Move the cursor to the beginning of the line |
||
|
Move the cursor to the end of the line |
||
|
Move the cursor up one screen |
||
|
Move the cursor down one screen |
||
|
Select the entire current document |
||
|
Select the word containing the cursor, or the closest word |
||
|
Reverse the last editing action |
||
|
Restore the previously undone edit |
||
|
Save the selected item |
||
|
Close |
||
|
Display the Go To Line dialog box |
||
|
Increase line indent |
||
|
Open a new query with current connection |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Output results in text format |
||
|
Toggle between query and results pane |
||
|
Show or hide the query results pane |
||
|
Run the sp_who system stored procedure |
||
|
Run the sp_lock system stored procedure |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
or
|
|||
or
|
|||
|
Swap the characters on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Delete one character to the right of the cursor |
||
|
Insert a new line |
||
|
Insert the number of spaces configured for the editor |
||
|
Toggle between insert mode and overtype mode |
||
|
Step into |
||
|
Step over |
||
|
Set next statement |
||
|
Toggle breakpoint |
||
|
Break at function |
||
|
Move to the next pane of a split pane view of a document |
||
|
Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window |
||
|
Display the New File dialog box to create a new file |
||
|
Help |
||
or
|
|||
|
Display SQL Server Books Online |
||
|
Change the name of the selected object |
||
|
Display help for the current editor window |
||
|
Display the Find dialog box |
||
|
Displays the definition for the selected symbol |
||
|
Display the Replace dialog box |
||
Advertisement |
|||
|
Find the next occurrence of the previous search text |
||
|
Find the previous occurrence of the search text |
||
|
Find the next occurrence of the currently selected text |
||
|
Cut (delete the currently selected item and place it to the Clipboard) |
||
|
Paste from the Clipboard at the insertion point |
||
|
Copy to the Clipboard |
||
|
Closes Activity Monitor |
||
|
Refresh |
||
|
Cycle through panels |
||
|
Copies entire selected row in grid |
||
|
Refresh |
||
|
Open a detail window from a grid |
||
|
Cancels or stops the currently running query |
||
|
Displays the diagram pane of the Query Designer |
||
|
Displays the criteria pane of the Query Designer |
||
|
Displays the SQL pane of the Query Designer |
||
|
Displays the results pane of the Query Designer |
||
|
Run the query specified in the Query Designer |
||
|
When in the results pane, moves focus to the tool strip docked at the bottom of the designer |
||
|
Move the selected control down in increments of 8 on the design surface |
||
|
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 |
||
|
Define filter |
||
|
Apply filter |
||
|
Show all columns |
||
|
Moves to the next control on the page |
||
|
Display the grid on the design surface |
||
|
Increases the height of the selected control in increments of 8 |
||
|
Reduces the width of the selected control in increments of 8 |
||
|
Increases the width of the selected control in increments of 8 |
||
|
Decreases the height of the selected control in increments of 8 |
||
|
Expand or collapse all panes |
||
or
|
|||
|
Copy cell |
||
|
Filter the monitor display |
||
|
Copy to the Clipboard |
||
|
Paste from the Clipboard at the insertion point |
||
|
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item |
||
|
Cut (delete the currently selected item and place it to the Clipboard) |
||
|
Find the previous occurrence of the currently selected text |
||
|
Display the Replace in Files dialog box |
||
|
Displays the list of references for the selected symbol |
||
|
Display the New Project dialog box to create a new project |
||
|
Move to the previous pane of a document in split pane view |
||
|
Refresh local cache |
||
|
Display the Breakpoints window |
||
|
Display the Threads window |
||
|
List members |
||
|
Complete word |
||
|
Enable breakpoint |
||
|
Implement the Run To Cursor command |
||
|
Display the QuickWatch dialog box |
||
|
Start or continue debugging |
||
|
Stop debugging |
||
|
Step out |
||
|
Delete the word to the right of the cursor |
||
|
Insert a blank line above the cursor |
||
|
Insert a new line |
||
|
Output results in a grid |
||
|
then |
||
|
Transpose the words on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Moves the line containing the cursor below the next line |
||
|
then |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
or
|
|||
or
|
|||
or
|
|||
or
|
|||
or
|
|||
|
Display the Query Designer dialog from the query editor window |
||
|
Copy the result grid and headers to the clipboard |
||
|
Move to the next active window in Management Studio |
||
|
Output results to a file |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Parse the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Open database in Object Explorer |
||
|
Specify values for template parameters |
||
|
Make the selected text lower case |
||
|
then |
||
|
then |
||
|
Open the current file in a browser |
||
|
Save all |
||
|
Restore the previously undone edit |
||
|
Scroll text up one line |
||
|
Scroll text down one line |
||
|
then |
||
|
Select the text from the current location of the cursor to the Navigate Backward ( |
||
|
then |
||
|
then |
||
|
then |
What is your favorite SQL Server Management Studio (SSMS) hotkey? Do you have any useful tips for it? Let other users know below.
1106799
498270
411259
366077
306918
277367
Yesterday
Yesterday
Yesterday
2 days ago
2 days ago Updated!
2 days ago Updated!
Latest articles