|
Move to the SQL Server Management Studio menu bar |
||
|
Activate the menu for a tool component |
||
|
Display the context menu |
||
|
Display the New File dialog box to create a file |
||
|
Display the New Project dialog box to create a new project |
||
|
Display the Open File dialog box to open an existing file |
||
|
Display the Open File dialog box to open an existing file |
||
|
Display the Open Project dialog box to open an existing project |
||
|
Display the Add New Item dialog box to add a new file to the current project |
||
|
Display the Add Existing Item dialog box to add an existing file to the current project |
||
|
Display the Query Designer |
||
|
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 |
||
|
|
||
|
Exit |
||
|
Toggle full screen mode |
||
|
Close the current tool window |
||
|
Cycle through the next MDI child windows |
||
|
Display the IDE navigator with the first document window selected |
||
|
Cycle through the previous MDI child windows |
||
|
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 |
||
|
Move to the current tool window toolbar |
||
|
Display the IDE navigator with the first tool window selected |
||
|
Move to the next tool window |
||
|
(in the Database Engine Query Editor) Move to the next tool window |
||
|
Move to the previous tool window |
||
|
Move to the next pane of a split pane view of a single document |
||
|
Move to the previously selected window |
||
|
(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 dock menu |
||
|
Display a popup listing all open windows |
||
|
Opens a new query editor window |
||
|
Display Object Explorer |
||
|
Display Registered Servers |
||
|
Display Template Explorer |
||
|
Display Solution Explorer |
||
|
Display the Summary Window |
||
|
Display the Properties Window |
||
|
Display the Output window |
||
|
then |
||
|
then |
||
|
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 |
||
|
Display the Toolbox |
||
|
then |
||
|
Display the Browser Window |
||
|
Display a smart tag menu of common commands for Web server controls in the HTML designer |
||
|
then |
||
|
|
||
|
then |
||
|
Move to the next entry in the Error List window (Transact-SQL Editor only) |
||
|
Display the previous page in the viewing history. Available only in the Web browser window |
||
|
Display the next page in the viewing history. Available only in the Web browser window |
|
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 to the beginning of the document |
||
|
Move the cursor to the end of the document |
||
|
Move the cursor up one screen |
||
|
Move the cursor down one screen |
||
|
Moves the cursor one word to the right |
||
|
Moves the cursor one word to the left |
||
|
Returns the cursor to the last item |
||
|
Moves the cursor to the top of the document |
||
|
Moves to the previous tab in the document |
||
|
Moves the cursor to the bottom of the document |
||
|
Moves to the next tab in the document |
|
Select text from the cursor to the beginning of the document |
||
|
Select text from the cursor to the end of the document |
||
|
Select text from the cursor to the start of the current line |
||
|
Moves the cursor to the start of the current line and extends the column selection |
||
|
Select text from the cursor to the end of the current line |
||
|
Moves the cursor to the end of the line, extending the column selection |
||
|
Select text down line by line starting from the cursor |
||
Note: I'm not sure if below shortcut is correct. It's listed in Microsoft's documents. Please let me know in comments if you know the correct one.
|
|||
|
Moves the cursor down one line, extending the column selection |
||
|
Moves the cursor one character to the left and extends the selection |
||
|
Moves the cursor one character to the left and extends the column selection |
||
|
Moves the cursor one character to the right and extends the selection |
||
|
Moves the cursor one character to the right and extends the column selection |
||
|
Select text up line by line starting from the cursor |
||
|
Move the cursor up one line, extending the selection |
||
|
Extend selection up one page |
||
|
Extend selection down one page |
||
|
Select the entire current document |
||
|
Select the word containing the cursor, or the closest word |
||
|
Select the current location in the editor, back to the previous location in the editor |
||
|
Extend the selection to the top of the current window |
||
|
Move the cursor to the last line in view, extending the selection |
||
|
Extend the selection one word to the right |
||
|
Extend the selection one word to the left |
||
|
Move the cursor to the right one word, extending the selection |
||
|
Move the cursor to the left one word, extending the selection |
||
|
Move the cursor to the next brace, extending the selection |
||
|
Select the text from the current location of the cursor to the Navigate Backward ( |
||
|
Go back to the previous document or window in the navigation history |
||
|
Go forward to the next document or window in the navigation history |
||
|
then |
||
|
Moves the cursor to the first line in view, extending the selection |
||
|
Moves the cursor to the last line in view, extending the selection |
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
||
|
then |
|
Toggle the full-screen display |
||
|
Scroll text up one line |
||
|
Scroll text down one line |
||
|
Reverse the last editing action |
||
or
|
|||
|
Restore the previously undone edit |
||
or
|
|||
or
|
|||
|
Save the selected item |
||
|
Save all |
||
|
Close |
||
|
|
||
|
Exit |
||
|
Open the current file in a browser |
||
|
Delete all text in the current file |
||
|
Display the Go To Line dialog box |
||
|
Display the Navigate To dialog box. |
||
|
Increase line indent |
||
|
Decrease line indent |
||
|
Make the selected text upper case |
||
|
Make the selected text lower case |
||
|
then |
||
|
then |
||
|
Open a new query with current connection |
||
|
Open database in Object Explorer |
||
|
Specify values for template parameters |
||
|
Run the selected portion of the query editor or the entire query editor if nothing is selected |
||
or
|
|||
|
Parse the selected portion of the query editor or the entire query editor if nothing is selected |
||
|
Display the estimated execution plan |
||
|
Cancel the executing query |
||
|
Include actual execution plan in the query output |
||
|
Output results in a grid |
||
|
Output results in text format |
||
|
Output results to a file |
||
|
Show or hide the query results pane |
||
|
Show the query results pane |
||
|
Toggle between query and results pane |
||
|
Copy the result grid and headers to the clipboard |
||
|
Move to the next active window in Management Studio |
||
|
Open SQL Server Profiler |
||
|
Display the Query Designer dialog from the query editor window |
||
|
Run the sp_help system stored procedure |
||
|
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
|
|||
or
|
|||
or
|
|||
or
|
|||
or
|
|||
or
|
|||
or
|
|
Insert a new line |
||
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 |
||
|
Delete one character to the left of the cursor |
||
or
|
|||
|
then |
||
|
Insert the number of spaces configured for the editor |
||
|
Insert a blank line above the cursor |
||
|
Insert a blank line below the cursor |
||
|
Change the selected text to lowercase |
||
|
Change the selected text to uppercase |
||
|
Toggle between insert mode and overtype mode |
||
|
Move selected lines to the left on tab stop |
||
|
Delete the word to the right of the cursor |
||
|
Delete the word to the left of the cursor |
||
|
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 |
||
|
Correctly indents the selected lines of code based on the surrounding lines of code |
||
|
Set or remove a shortcut in the current line |
||
|
Remove the comment syntax from the current line |
||
|
Shows or hides spaces and tabs |
||
|
Enables or disables word wrap in an editor |
||
|
Collapses all outlining regions to show just the outermost groups in the hierarchy |
||
|
Collapses the currently selected outlining region |
||
|
Expands all outlining regions on the page |
||
|
Expands the currently selected outlining region |
||
|
Collapses existing outlining regions |
||
|
Hides the selected text. A signal icon marks the location of the hidden text |
||
|
Toggles all text sections previously marked as hidden between the hidden and display states |
||
|
Toggles the currently selected hidden text section between the hidden and display states |
||
|
Removes all outlining information in the document |
||
|
Removes the outlining information for the currently selected region |
|
Start or continue debugging |
||
|
Stop debugging |
||
|
Step into |
||
|
Step over |
||
|
Step out |
||
|
Step into specific statement |
||
|
Set next statement |
||
|
Show next statement |
||
|
Implement the Run To Cursor command |
||
|
Display the QuickWatch dialog box |
||
or
|
|||
|
Toggle breakpoint |
||
|
Enable breakpoint |
||
|
D Delete the breakpoint. Only available in the Breakpoints window |
||
|
L Open the Edit breakpoint labels dialog. Only available in the Breakpoints window |
||
|
Delete all breakpoints |
||
|
Display the Breakpoints window |
||
|
Break all |
||
|
Break at function |
||
|
Display the Watch 1 window |
||
|
Display the Watch 2 window |
||
|
Display the Watch 3 window |
||
|
Display the Watch 4 window |
||
|
Display the Autos window |
||
|
Display the Locals window |
||
|
Display the Immediate window |
||
|
Display the Call Stack window |
||
|
Display the Threads window |
||
|
Display the Parallel Stacks window |
||
|
Display the Parallel Tasks window |
|
List members |
||
|
Complete word |
||
or
|
|||
|
Display quick information |
||
|
Display parameter information |
||
|
Copy parameter tip |
||
|
Paste parameter tip |
||
|
Jump between syntax pairs |
||
|
Launch code snippet picker |
||
|
Refresh local cache |
||
|
Launch Surround With snippet picker |
||
|
Display the Code Snippet Manager |
||
|
Changes the IntelliSense filter level from the Common tab to the All tab |
||
|
Changes the IntelliSense filter level from the All tab to the Common tab |
|
Toggle full-screen mode |
||
|
Move to the next pane of a split pane view of a document |
||
|
Move to the previous document in the editor or designer |
||
or
|
|||
|
Move to the previous pane of a document in split pane view |
||
|
Back, display the previous page in the viewing history |
||
|
Forward, display the next page in the viewing history |
||
|
Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window |
|
Display Solution Explorer |
||
|
Display the New File dialog box to create a new file |
||
|
Display the New Project dialog box to create a new project |
||
|
Display the Open File dialog box to open an existing file |
||
|
Change the name of the selected object |
|
Help |
||
or
|
|||
|
Display SQL Server Books Online |
||
|
Open the Help Library Manager |
||
|
Display the SQL Server Resource Center Web page |
||
|
Display help for the current editor window |
|
Display the Find dialog box |
||
|
Displays the definition for the selected symbol |
||
|
Displays the list of references for the selected symbol |
||
|
Display the Replace dialog box |
||
|
Start incremental search. Type the characters to search for or press |
||
|
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 |
||
|
Find the previous occurrence of the currently selected text |
||
|
Display the Replace in Files dialog box |
||
|
Reverse incremental search so it starts at the bottom of the file and searches to the top |
||
|
Select or clear the Search up option in Find and Replace |
||
|
Stop the Find in Files search |
||
|
Select or clear the Find whole word option in Find and Replace |
||
|
Select or clears the Wildcard option in Find and Replace |
||
|
Place the caret in the Find/Command box of the Standard toolbar |
|
Cut (delete the currently selected item and place it to the Clipboard) |
||
or
|
|||
|
Cuts all of the selected lines, or the current line if nothing is selected |
||
or
|
|||
|
Copy to the Clipboard |
||
or
|
|||
|
Paste from the Clipboard at the insertion point |
||
or
|
|||
|
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item |
||
or
|
|
Launches Activity Monitor |
||
|
Closes Activity Monitor |
||
|
Refresh |
||
|
Filter the monitor display |
||
|
Cycle through panels |
||
|
Expand or collapse selected pane |
||
or
|
|||
|
Expand or collapse all panes |
||
or
|
|||
|
Copies entire selected row in grid |
||
|
Copy cell |
||
|
Drop-down for filtering in grid |
|