|
|
||
or
|
|||
|
Step out |
||
|
Help |
||
|
Refresh |
||
or
|
|||
|
Toggle breakpoint |
||
|
Step into |
||
|
Step over |
||
|
Save all |
||
|
Exit |
||
or
|
|||
|
Close |
||
|
Help |
||
|
Toggle full screen mode |
||
|
Toggle full-screen mode |
||
|
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 |
||
|
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 |
||
|
Increase line indent |
||
|
Insert the number of spaces configured for the editor |
||
|
Moves to the next control on the page |
||
|
Insert a new line |
||
|
Open a detail window from a grid |
||
|
Display the grid on the design surface |
||
|
Copy to the Clipboard |
||
|
Copies entire selected row in grid |
||
|
Save the selected item |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
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 cursor down |
||
|
Move the selected control down in increments of 8 on the design surface |
||
|
Display the New File dialog box to create a file |
||
|
Open a new query with current connection |
||
|
Display the New File dialog box to create a new file |
||
|
Display the Open File dialog box to open an existing file |
||
|
Opens a new query editor window |
||
|
Display the Open File dialog box to open an existing file |
||
|
Start incremental search. Type the characters to search for or press |
||
|
Show or hide the query results pane |
||
|
Run the query specified in the Query Designer |
||
|
Display the Properties Window |
||
|
Restore the previously undone edit |
||
|
(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 |
||
Advertisement |
|||
|
Toggle between Object Explorer Details list view and Object Explorer Details property pane |
||
|
Toggle between query and results pane |
||
|
Move to the next pane of a split pane view of a document |
||
|
Cycle through panels |
||
|
Define filter |
||
|
Break at function |
||
|
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 |
||
|
Display the Go To Line dialog box |
||
|
When in the results pane, moves focus to the tool strip docked at the bottom of the designer |
||
|
Display Object Explorer |
||
|
Show all columns |
||
|
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 |
||
|
Delete one character to the left of the cursor |
||
|
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 |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
Display the Replace dialog box |
||
|
(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 |
||
|
Decrease line indent |
||
|
Move selected lines to the left on tab stop |
||
|
Moves to the previous control on the page |
||
|
Run the sp_who system stored procedure |
||
|
Displays the diagram pane of the Query Designer |
||
|
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 the tree control down in the window |
||
|
Scroll text down one line |
||
|
Scroll the tree control up in the window |
||
|
Scroll text up one line |
||
|
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 |
||
|
Go back to the previous document or window in the navigation history |
||
|
Expand or collapse selected pane |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Insert a new line |
||
|
Move to the SQL Server Management Studio menu bar |
||
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog |
||
|
Set next statement |
||
|
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 |
||
|
Display the next page in the viewing history. Available only in the Web browser window |
||
|
Complete word |
||
|
Forward, display the next page in the viewing history |
||
|
Specify values for template parameters |
||
|
Output results to a file |
||
|
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. |
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
40 minutes ago
11 hours ago Updated!
17 hours ago
1 days ago
2 days ago Updated!
3 days ago
Latest articles