|
Extend the selection to the top of the current window |
||
|
Moves the cursor to the first line in view, extending the selection |
||
|
Moves the cursor to the last line in view, extending the selection |
||
|
Move the cursor to the last line in view, extending the selection |
||
|
Insert a blank line below the cursor |
||
|
Enables JOIN mode in the Query Designer |
||
|
Open SQL Server Profiler |
||
|
Display the Navigate To dialog box. |
||
|
Expand or collapse selected pane |
||
or
|
|||
|
Go back to the previous document or window in the navigation history |
||
|
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item |
||
|
Move to the previous pane of a document in split pane view |
||
|
(in the Database Engine Query Editor) Move to the next pane of a split pane view of a single document |
||
|
Move to the previous pane of a split pane view of a single document |
||
|
Display the Open File dialog box to open an existing file |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
Scroll text up one line |
||
|
Scroll the tree control up in the window |
||
|
Scroll the tree control down in the window |
||
|
Scroll text down one line |
||
|
Parse the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Refresh local cache |
||
|
Display Registered Servers |
||
|
Insert a blank line above the cursor |
||
|
Insert a new line |
||
|
Display the Replace in Files dialog box |
||
|
Output results in a grid |
||
|
Moves the cursor one word to the left |
||
|
Moves the cursor one word to the right |
||
|
Expand or collapse all panes |
||
or
|
|||
|
(on the numeric keypad) Collapse tree nodes |
||
|
Move the cursor to the beginning of the document |
||
|
Move the cursor to the end of the document |
||
|
Moves the cursor to the top of the document |
||
|
Moves to the previous tab in the document |
||
|
Transpose the words on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Output results to a file |
||
|
Display the New Project dialog box to create a new project |
||
or
|
|||
|
Copy the result grid and headers to the clipboard |
||
|
Copy cell |
||
|
Save all |
||
|
Stop debugging |
||
|
Display the Query Designer dialog from the query editor window |
||
|
Display the Query Designer |
||
|
Specify values for template parameters |
||
Advertisement |
|||
|
Make the selected text lower case |
||
|
List members |
||
|
Display the Add New Item dialog box to add a new file to the current project |
||
|
Moves the cursor to the bottom of the document |
||
|
Moves to the next tab in the document |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Restore the previously undone edit |
||
|
Display the IDE navigator with the first tool window selected |
||
|
Select the current location in the editor, back to the previous location in the editor |
||
|
Select the text from the current location of the cursor to the Navigate Backward ( |
||
|
Delete the word to the right of the cursor |
||
|
Display the context menu |
||
|
Find the previous occurrence of the currently selected text |
||
|
Displays the list of references for the selected symbol |
||
|
Step out |
||
|
Display the Threads window |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
or
|
|||
or
|
|||
|
Display the QuickWatch dialog box |
||
|
Extend selection up one page |
||
|
Copy to the Clipboard |
||
|
Paste from the Clipboard at the insertion point |
||
|
Start or continue debugging |
||
|
Move to the next active window in Management Studio |
||
|
Move to the next tool window |
||
|
Reduces the width of the selected control in increments of 8 |
||
|
Moves the cursor one character to the left and extends the selection |
||
|
Moves the cursor one character to the right and extends the selection |
||
|
Increases the width of the selected control in increments of 8 |
||
|
Decreases the height of the selected control in increments of 8 |
||
|
Select text up line by line starting from the cursor |
||
|
Select text down line by line starting from the cursor |
||
|
Increases the height of the selected control in increments of 8 |
||
|
Select text from the cursor to the start of the current line |
||
|
Select text from the cursor to the end of the current line |
||
|
Complete word |
||
|
Display Template Explorer |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Open the current file in a browser |
||
|
(on the numeric keypad) Expand all tree nodes |
||
|
Cut (delete the currently selected item and place it to the Clipboard) |
||
|
Cycle through the next MDI child windows |
||
|
Enable breakpoint |
||
|
Moves the line containing the cursor below the next line |
||
|
Implement the Run To Cursor command |
||
|
Open database in Object Explorer |
||
|
Display the Breakpoints window |
||
|
Close the current tool window |
||
|
Filter the monitor display |
||
|
Returns the cursor to the last item |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Extend selection down one page |
||
|
Help |
||
|
Display help for the current editor 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 |
||
|
Display SQL Server Books Online |
||
|
Toggle breakpoint |
||
|
Step over |
||
|
Toggle between insert mode and overtype mode |
||
|
Find the next occurrence of the currently selected text |
||
|
Set next statement |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Displays the SQL pane of the Query Designer |
||
|
Displays the results pane of the Query Designer |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Display Object Explorer |
||
|
Show all columns |
||
|
Move the cursor up one screen |
||
|
Move the cursor down one screen |
||
|
Run the sp_lock system stored procedure |
||
|
Displays the criteria pane of the Query Designer |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Display the Replace dialog box |
||
|
Displays the definition for the selected symbol |
||
|
Run the sp_who system stored procedure |
||
|
Displays the diagram pane of the Query Designer |
||
|
Output results in text format |
||
|
Swap the characters on either side of the cursor (Does not apply to the SQL Editor) |
||
|
Cancels or stops the currently running query |
||
|
Open a new query with current connection |
||
|
Display the New File dialog box to create a new file |
||
|
Display the New File dialog box to create a file |
||
|
Help |
||
|
Display the Summary Window |
||
|
Apply filter |
||
|
Change the name of the selected object |
||
|
Insert the number of spaces configured for the editor |
||
|
Increase line indent |
||
|
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 |
What is your favorite SQL Server Management Studio (SSMS) hotkey? Do you have any useful tips for it? Let other users know below.
1104365
497159
410705
364136
305770
276264
24 hours ago
Yesterday Updated!
2 days ago
2 days ago Updated!
2 days ago
2 days ago Updated!
Latest articles