SQL Server Management Studio Keyboard Shortcuts
SQL Server Management Studio offers users two keyboard schemes. By default, it uses the SQL Server 2017 scheme, with keyboard shortcuts based on Microsoft Visual Studio 2010. Management Studio also offers a keyboard scheme similar to the standard scheme from SQL Server 2008 R2. To change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. Select the desired keyboard scheme on the Environment, Keyboard page
Code Editor Keyboard Shortcuts
Menu Activation Keyboard Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Move to the SQL Server Management Studio menu bar
|
ALT
|
ALT
|
Activate the menu for a tool component
|
ALT+HYPHEN
|
ALT+HYPHEN
|
Display the context menu
|
SHIFT+F10
|
SHIFT+F10
|
Display the New File dialog
box to create a file
|
CTRL+N
|
CTRL+N
|
Display the New Project dialog
box to create a new project
|
CTRL+SHIFT+N
|
CTRL+SHIFT+N
|
Display the Open File dialog
box to open an existing file
|
CTRL+O
|
CTRL+O
|
or
|
||
CTRL+SHIFT+G
|
||
Display the Open Project dialog
box to open an existing project
|
CTRL+SHIFT+O
|
CTRL+SHIFT+O
|
Display the Add New Item dialog
box to add a new file to the current project
|
CTRL+SHIFT+A
|
CTRL+SHIFT+A
|
Display the Add Existing
Item dialog box to add an existing file to the current project
|
SHIFT+ALT+A
|
SHIFT+ALT+A
|
Display the Query Designer
|
CTRL+SHIFT+Q
|
CTRL+SHIFT+Q
|
Close a menu or dialog box, cancelling the action
|
ESC
|
ESC
|
Windows Management and Toolbar Keyboard
Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Close the current MDI child window
|
CTRL+F4
|
CTRL+F4
|
Close a menu or dialog box, cancels an operation in progress, or
focuses on the current document window
|
ESC
|
ESC
|
Print
|
CTRL+P
|
CTRL+P
|
Exit
|
ALT+F4
|
ALT+F4
|
Toggle full screen mode
|
SHIFT+ALT+ENTER
|
SHIFT+ALT+ENTER
|
Close the current tool window
|
SHIFT+ESC
|
SHIFT+ESC
|
Cycle through the next MDI child windows
|
CTRL+F6
|
CTRL+TAB
|
Display the IDE navigator with the first document window selected
|
CTRL+TAB
|
No equivalent
|
Cycle through the previous MDI child windows
|
CTRL+SHIFT+TAB
|
CTRL+SHIFT+TAB
|
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
|
CTRL+F2
|
No equivalent
|
Move to the current tool window toolbar
|
SHIFT+ALT
|
SHIFT+ALT
|
Display the IDE navigator with the first tool window selected
|
ALT+F7
|
No equivalent
|
Move to the next tool window
|
ALT+F6
|
ALT+F6
|
or
|
||
F6 in the Database Engine Query Editor
|
||
Move to the previous tool window
|
SHIFT+ALT+F7
|
SHIFT+ALT+F7
|
Move to the next pane of a split pane view of a single document
|
F6
|
F6
|
Move to the previously selected window
|
SHIFT+ALT+F6
|
SHIFT+ALT+F6
|
or
|
||
SHIFT+F6 in the Database Engine Query
Editor
|
||
Move to the previous pane of a split pane view of a single document
|
SHIFT+F6
|
F6
|
Display the dock menu
|
ALT+MINUS SIGN (-)
|
No equivalent
|
Display a popup listing all open windows
|
CTRL+ALT+DOWN ARROW
|
No equivalent
|
Opens a new query editor window
|
CTRL+O
|
CTRL+O
|
Display Object Explorer
|
F8
|
F8
|
Display Registered Servers
|
CTRL+ALT+G
|
CTRL+ALT+G
|
Display Template Explorer
|
CTRL+ALT+T
|
CTRL+ALT+T
|
Display Solution Explorer
|
CTRL+ALT+L
|
CTRL+ALT+L
|
Display the Summary Window
|
F7
|
F7
|
Display the Properties Window
|
F4
|
F4
|
Display the Output window
|
CTRL+ALT+O
|
No equivalent
|
Display the Task List window
|
CTRL+\, T
|
CTRL+ALT+K
|
or
|
||
CTRL+\, CTRL+T
|
||
Toggle between Object Explorer Details list view and Object Explorer
Details property pane.
|
F6
|
F6
|
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.
|
TAB, then UP arrow or DOWN arrow
|
TAB, then UP arrow or DOWN arrow
|
Display the Toolbox
|
CTRL+ALT+X
|
CTRL+ALT+X
|
Display the Bookmarks Window
|
CTRL+K, CTRL+W
|
CTRL+K, CTRL+W
|
Display the Browser Window
|
CTRL+ALT+R
|
CTRL+ALT+R
|
Display a smart tag menu of common commands for Web server controls in
the HTML designer
|
SHIFT+ALT+F10
|
No equivalent
|
Display the Error List Window (Transact-SQL Editor only)
|
CRTL+\, CTRL+E
|
CRTL+\, CTRL+E
|
or
|
||
CTRL+\, E
|
||
Move to the next entry in the Error List window (Transact-SQL Editor
only)
|
CTRL+SHIFT+F12
|
CTRL+SHIFT+F12
|
Display the previous page in the viewing history. Available only in
the Web browser window
|
ALT+LEFT ARROW
|
No equivalent
|
Display the next page in the viewing history. Available only in the
Web browser window
|
ALT+RIGHT ARROW
|
No equivalent
|
Cursor Movement Keyboard Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Move the cursor left
|
LEFT ARROW
|
LEFT ARROW
|
Move the cursor right
|
RIGHT ARROW
|
RIGHT ARROW
|
Move the cursor up
|
UP ARROW
|
UP ARROW
|
Move the cursor down
|
DOWN ARROW
|
DOWN ARROW
|
Move the cursor to the beginning of the line
|
HOME
|
HOME
|
Move the cursor to the end of the line
|
END
|
END
|
Move the cursor to the beginning of the document
|
CTRL+HOME
|
CTRL+HOME
|
Move the cursor to the end of the document
|
CTRL+END
|
CTRL+END
|
Move the cursor up one screen
|
PAGE UP
|
PAGE UP
|
Move the cursor down one screen
|
PAGE DOWN
|
PAGE DOWN
|
Moves the cursor one word to the right
|
CTRL+ RIGHT ARROW
|
CTRL+ RIGHT ARROW
|
Moves the cursor one word to the left
|
CTRL+ LEFT ARROW
|
CTRL+ LEFT ARROW
|
Returns the cursor to the last item.
|
SHIFT+F8
|
No equivalent
|
Moves the cursor to the top of the document
|
CTRL+PAGE UP
|
No equivalent
|
Moves to the previous tab in the document
|
CTRL+PAGE UP
|
|
Moves the cursor to the bottom of the document
|
CTRL+PAGE DOWN
|
No equivalent
|
Moves to the next tab in the document
|
CTRL+PAGE DOWN
|
No equivalent
|
Text Selection Keyboard Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Select text from the cursor to the beginning of the document
|
CTRL+SHIFT+ HOME
|
CTRL+SHIFT+ HOME
|
Select text from the cursor to the end of the document
|
CTRL+SHIFT+END
|
CTRL+SHIFT+END
|
Select text from the cursor to the start of the current line
|
SHIFT+HOME
|
SHIFT+HOME
|
Moves the cursor to the start of the current line and extends the
column selection
|
SHIFT+ALT+HOME
|
No equivalent
|
Select text from the cursor to the end of the current line
|
SHIFT+END
|
SHIFT+END
|
Moves the cursor to the end of the line, extending the column
selection.
|
SHIFT+ALT+END
|
No equivalent
|
Select text down line by line starting from the cursor
|
SHIFT+ DOWN ARROW
|
SHIFT+ DOWN ARROW
|
Moves the cursor down one line, extending the column selection
|
SHIFT+ Ctrl+Shift+Del
|
|
Moves the cursor one character to the left and extends the selection
|
SHIFT+LEFT ARROW
|
No equivalent
|
Moves the cursor one character to the left and extends the column
selection
|
SHIFT+ALT+LEFT ARROW
|
No equivalent
|
Moves the cursor one character to the right and extends the selection
|
SHIFT+RIGHT ARROW
|
No equivalent
|
Moves the cursor one character to the righTt and extends the column
selection
|
SHIFT+ALT+RIGHT ARROW
|
No equivalent
|
Select text up line by line starting from the cursor
|
SHIFT+UP ARROW
|
SHIFT+UP ARROW
|
Move the cursor up one line, extending the selection
|
SHIFT+ALT+ UP ARROW
|
SHIFT+ALT+ UP ARROW
|
Extend selection up one page
|
SHIFT+ PAGE UP
|
SHIFT+ PAGE UP
|
Extend selection down one page
|
SHIFT+ PAGE DOWN
|
SHIFT+ PAGE DOWN
|
Select the entire current document
|
CTRL+A
|
CTRL+A
|
Select the word containing the cursor, or the closest word
|
CTRL+W
|
CTRL+W
|
Select the current location in the editor, back to the previous
location in the editor
|
CTRL+=
|
CTRL+=
|
Extend the selection to the top of the current window
|
CTRL+SHIFT+ PAGE UP
|
CTRL+SHIFT+ PAGE UP
|
Move the cursor to the last line in view, extending the selection
|
CTRL+SHIFT+ PAGE DOWN
|
CTRL+SHIFT+ PAGE DOWN
|
Extend the selection one word to the right
|
CTRL+SHIFT+ RIGHT ARROW
|
CTRL+SHIFT+ RIGHT ARROW
|
Extend the selection one word to the left
|
CTRL+SHIFT+ LEFT ARROW
|
CTRL+SHIFT+ LEFT ARROW
|
Move the cursor to the right one word, extending the selection
|
CTRL+SHIFT+ALT+ RIGHT ARROW
|
CTRL+SHIFT+ALT+ RIGHT ARROW
|
Move the cursor to the left one word, extending the selection
|
CTRL+SHIFT+ALT+ LEFT ARROW
|
CTRL+SHIFT+ALT+ LEFT ARROW
|
Move the cursor to the next brace, extending the selection
|
CTRL+SHIFT+]
|
No equivalent
|
Select the text from the current location of the cursor to the
Navigate Backward (CTRL+MINUS SIGN (-)) location
|
CTRL+EQUAL SIGN (=)
|
No equivalent
|
Go back to the previous document or window in the navigation history
|
CTRL+MINUS SIGN (-)
|
No equivalent
|
Go forward to the next document or window in the navigation history
|
CTRL+SHIFT+MINUS SIGN (-)
|
No equivalent
|
Swaps the anchor and end points of the current selection
|
CTRL+K, CTRL+A
|
No equivalent
|
Moves the cursor to the first line in view, extending the selection
|
CTRL+SHIFT+PAGE UP
|
No equivalent
|
Moves the cursor to the last line in view, extending the selection
|
CTRL+SHIFT+PAGE DOWN
|
No equivalent
|
Bookmark Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Set or
remove a bookmark at the current line
|
CTRL+K,
CTRL+K
|
CTRL+K,
CTRL+K
|
Next
bookmark
|
CTRL+K,
CTRL+N
|
CTRL+K,
CTRL+N
|
Previous
bookmark
|
CTRL+K,
CTRL+P
|
CTRL+K,
CTRL+P
|
If the
current bookmark is in a folder, moves to the next bookmark in the folder.
Bookmarks outside the folder are skipped.
If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped. |
CTRL+SHIFT+K,
CTRL+SHIFT+P
|
No
equivalent
|
Clear
bookmarks
|
CTRL+K,
CTRL+L
|
CTRL+K,
CTRL+L
|
Tree Control Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Collapse
tree nodes
|
- (on
the numeric keypad)
|
- (on
the numeric keypad)
|
Expand
all tree nodes
|
* (on
the numeric keypad)
|
* (on
the numeric keypad)
|
Scroll
the tree control up in the window
|
CTRL+UP
ARROW
|
CTRL+UP
ARROW
|
Scroll
the tree control down in the window
|
CTRL+DOWN
ARROW
|
CTRL+DOWN
ARROW
|
Text Manipulation in Code Editor
Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Insert
a new line
|
ENTER
or SHIFT+ENTER
|
ENTER
or SHIFT+ENTER
|
Swap the
characters on either side of the cursor (Does not apply to the SQL Editor.)
|
CTRL+T
|
CTRL+T
|
Delete
one character to the right of the cursor
|
DELETE
|
DELETE
|
Delete
one character to the left of the cursor
|
BACKSPACE
or SHIFT+ BACKSPACE |
BACKSPACE
or SHIFT+ BACKSPACE |
Delete
whitespace in the selection, or deletes whitespace adjacent to the cursor if
there is no selection
|
CTRL+K,
C
|
No
equivalent
|
Insert
the number of spaces configured for the editor
|
TAB
|
TAB
|
Insert
a blank line above the cursor
|
CTRL+ENTER
|
CTRL+ENTER
|
Insert
a blank line below the cursor
|
CTRL+SHIFT+
ENTER
|
CTRL+SHIFT+
ENTER
|
Change
the selected text to lowercase
|
CTRL+SHIFT+L
|
CTRL+SHIFT+L
|
Change
the selected text to uppercase
|
CTRL+SHIFT+U
|
CTRL+SHIFT+U
|
Toggle
between insert mode and overtype mode
|
INSERT
|
INSERT
|
Move
selected lines to the left on tab stop
|
SHIFT+TAB
|
SHIFT+TAB
|
Delete
the word to the right of the cursor
|
CTRL+DELETE
|
CTRL+DELETE
|
Delete
the word to the left of the cursor
|
CTRL+BACKSPACE
|
CTRL+BACKSPACE
|
Transpose
the words on either side of the cursor (Does not apply to the SQL Editor.)
|
CTRL+SHIFT+T
|
CTRL+SHIFT+T
|
Moves
the line containing the cursor below the next line
|
SHIFT+ALT+T
|
No
equivalent
|
Applies
the indenting and space formatting for the language specified on the Formatting pane
of the language in the Text Editor section of the Options dialog.
Available only in the text editor.
|
CTRL+K,
CTRL+D
|
No
equivalent
|
Correctly
indents the selected lines of code based on the surrounding lines of code
|
CTRL+K,
CTRL+F
|
No
equivalent
|
Set or
remove a shortcut in the current line
|
CTRL+K,
CTRL+H
|
No
equivalent
|
Remove
the comment syntax from the current line
|
CTRL+K,
CTRL+U
|
No
equivalent
|
Shows
or hides spaces and tabs
|
CTRL+R,
CTRL+W
|
No
equivalent
|
Enables
or disables word wrap in an editor
|
Alt+F,
CTRL+W
|
No
equivalent
|
Collapses
all outlining regions to show just the outermost groups in the hierarchy
|
CTRL+M,
CTRL+A
|
No
equivalent
|
Collapses
the currently selected outlining region
|
CTRL+M,
CTRL+S
|
No equivalent
|
Expands
all outlining regions on the page
|
CTRL+M,
CTRL+X
|
No
equivalent
|
Expands
the currently selected outlining region
|
CTRL+M,
CTRL+E
|
No
equivalent
|
Collapses
existing outlining regions
|
CTRL+M,
CTRL+O
|
|
Hides
the selected text. A signal icon marks the location of the hidden text
|
CTRL+M,
CTRL+H
|
No
equivalent
|
Toggles
all text sections previously marked as hidden between the hidden and display
states.
|
CTRL+M,
CTRL+L
|
No
equivalent
|
Toggles
the currently selected hidden text section between the hidden and display
states
|
CTRL+M,
CTRL+M
|
No
equivalent
|
Removes
all outlining information in the document
|
CTRL+M,
CTRL+P
|
No
equivalent
|
Removes
the outlining information for the currently selected region
|
CTRL+M,
CTRL+U
|
No
equivalent
|
Code Editor Keyboard Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Toggle the full-screen display
|
SHIFT+ALT+ENTER
|
SHIFT+ALT+ENTER
|
Scroll text up one line
|
CTRL+UP ARROW
|
CTRL+UP ARROW
|
Scroll text down one line
|
CTRL+DOWN ARROW
|
CTRL+ DOWN ARROW
|
Reverse the last editing action
|
CTRL+Z
|
CTRL+Z
|
|
||
or
|
||
|
||
ALT+BACKSPACE
|
||
Restore the previously undone edit
|
CTRL+SHIFT+Z
|
CTRL+SHIFT+Z
|
|
|
|
or
|
or
|
|
|
|
|
CTRL+Y
|
CTRL+Y
|
|
|
|
|
or
|
or
|
|
|
|
|
ALT+SHIFT+BACKSPACE
|
ALT+SHIFT+BACK SPACE
|
|
Save the selected item
|
CTRL+S
|
CTRL+S
|
Save all
|
CTRL+SHIFT+S
|
CTRL+SHIFT+S
|
Close
|
CTRL+F4
|
CTRL+F4
|
Print
|
CTRL+P
|
CTRL+P
|
Exit
|
ALT+F4
|
ALT+F4
|
Open the current file in a browser
|
CTRL+SHIFT+W
|
No equivalent
|
Delete all text in the current file
|
CTRL+SHIFT+DEL
|
CTRL+SHIFT+DEL
|
Display the Go To Line dialog box
|
CTRL+G
|
CTRL+G
|
Display the Navigate To dialog box.
|
CTRL+PLUS SIGN (+)
|
No equivalent
|
Increase line indent
|
TAB
|
TAB
|
Decrease line indent
|
SHIFT+TAB
|
SHIFT+TAB
|
Make the selected text upper case
|
CTRL+SHIFT+U
|
CTRL+SHIFT+U
|
Make the selected text lower case
|
CTRL+U
|
CTRL+SHIFT+L
|
Make the selected text a comment
|
CTRL+K, CTRL+C
|
CTRL+K, CTRL+C
|
Uncomment the selected text
|
CTRL+K, CTRL + U
|
CTRL+K, CTRL + U
|
Open a new query with current connection
|
CTRL+N
|
CTRL+N
|
Open database in Object Explorer
|
ALT+F8
|
ALT+F8
|
Specify values for template parameters
|
CTRL+SHIFT+M
|
CTRL+SHIFT+M
|
Run the selected portion of the query editor or the entire query
editor if nothing is selected
|
F5
|
F5
|
|
|
|
or
|
or
|
|
|
|
|
CTRL+SHIFT+E
|
CTRL+E
|
|
|
|
|
|
or
|
|
|
|
|
|
ALT+X
|
|
Parse the selected portion of the query editor or the entire query
editor if nothing is selected
|
CTRL+F5
|
CTRL+F5
|
Display the estimated execution plan
|
CTRL+SHIFT+ALT+L
|
CTRL+L
|
Cancel the executing query
|
ALT+BREAK
|
ALT+BREAK
|
Include actual execution plan in the query output
|
CTRL+SHIFT+ALT+M
|
CTRL+M
|
Output results in a grid
|
CTRL+SHIFT+D
|
CTRL+D
|
Output results in text format
|
CTRL+T
|
CTRL+T
|
Output results to a file
|
CTRL+SHIFT+T
|
CTRL+SHIFT+F
|
Show or hide the query results pane
|
CTRL+R
|
CTRL+R
|
Show the query results pane
|
CTRL+SHIFT+ALT+R
|
|
Toggle between query and results pane
|
F6
|
F6
|
Copy the result grid and headers to the clipboard
|
CTRL+SHIFT+C
|
No equivalent
|
Move to the next active window in Management Studio
|
ALT+F6
|
ALT+F6
|
Open SQL Server Profiler
|
CTRL+ALT+P
|
CTRL+ALT+P
|
Display the Query Designer dialog from the query editor window
|
CTRL+SHIFT+Q
|
No equivalent
|
Run the sp_help system stored procedure
|
ALT+F1
|
ALT+F1
|
Run the sp_who system stored procedure
|
CTRL+1
|
CTRL+1
|
Run the sp_lock system stored procedure
|
CTRL+2
|
CTRL+2
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+3
|
CTRL+3
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+4
|
CTRL+4
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+5
|
CTRL+5
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+6
|
CTRL+6
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+7
|
CTRL+7
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+7
|
CTRL+7
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+8
|
CTRL+8
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+9
|
CTRL+9
|
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query
Shortcutsdialog
|
CTRL+0
|
CTRL+0
|
Transact-SQL Debugger Keyboard Shortcuts
Action
|
SQL Server 2017
|
SQL Server 2008 R2
|
Start or continue debugging
|
ALT+F5
|
ALT+F5
|
Stop debugging
|
SHIFT+F5
|
SHIFT+F5
|
Step into
|
F11
|
F11
|
Step over
|
F10
|
F10
|
Step out
|
SHIFT+F11
|
SHIFT+F11
|
Step into specific statement
|
SHIFT+ALT+F11
|
No equivalent
|
Set next statement
|
Ctrl+3 0
|
No equivalent
|
Show next statement
|
ALT+NUM
|
No equivalent
|
Implement the Run To Cursor command
|
CTRL+F10
|
CTRL+F10
|
Display the QuickWatch dialog box
|
CTRL+ALT+Q
or SHIFT+F9 |
CTRL+ALT+Q
|
Toggle breakpoint
|
F9
|
F9
|
Enable breakpoint
|
CTRL+F9
|
No equivalent
|
Delete the breakpoint. Only available in the Breakpointswindow
|
ALT+F9, D
|
No equivalent
|
Open the Edit breakpoint labels dialog. Only available in the Breakpoints window
|
ALT+F9, L
|
No equivalent
|
Delete all breakpoints
|
CTRL+SHIFT+F9
|
CTRL+SHIFT+F9
|
Display the Breakpoints window
|
CTRL+ALT+B
|
CTRL+ALT+B
|
Break all
|
CTRL+ALT+BREAK
|
CTRL+ALT+BREAK
|
Break at function
|
CTRL+B
|
No equivalent
|
Display the Watch 1 window
|
CTRL+ALT+W, 1
|
No equivalent
|
Display the Watch 2 window
|
CTRL+ALT+W, 2
|
CTRL+ALT+W, 1
|
Display the Watch 3 window
|
CTRL+ALT+W, 3
|
CTRL+ALT+W, 3
|
Display the Watch 4 window
|
CTRL+ALT+W, 4
|
CTRL+ALT+W, 4
|
Display the Autos window
|
CTRL+ALT+V, A
|
CTRL+ALT+V, A
|
Display the Locals window
|
CTRL+ALT+V, L
|
CTRL+ALT+V, L
|
Display the Immediate window
|
CTRL+ALT+I
|
CTRL+ALT+I
|
Display the Call Stack window
|
CTRL+ALT+C
|
CTRL+ALT+C
|
Display the Threads window
|
CTRL+ALT+H
|
CTRL+ALT+H
|
Display the Parallel Stacks window.
|
CTRL+SHIFT+D, S
|
No equivalent
|
Display the Parallel Tasks window
|
CTRL_SHIFT+D, K
|
No equivalent
|
Microsoft IntelliSense Keyboard
Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
List
members
|
CTRL+J
|
CTRL+SPACE
or CTRL+J |
Complete
word
|
CTRL+SPACE
or ALT+RIGHT ARROW |
ALT+RIGHT
ARROW
|
Display
quick information
|
CTRL+K,
CTRL+I
|
No
equivalent
|
Display
parameter information
|
CTRL+SHIFT+SPACE
|
CTRL+SHIFT+SPACE
|
Copy
parameter tip
|
CTRL+SHIFT+ALT+C
|
No
equivalent
|
Paste
parameter tip
|
CTRL+SHIFT+ALT+P
|
No
equivalent
|
Jump
between syntax pairs
|
CTRL+]
|
CTRL+]
|
Launch
code snippet picker
|
CTRL+K,
CTRL+X
|
CTRL+K,
CTRL+Z
|
Refresh
local cache
|
CTRL+SHIFT+R
|
CTRL+SHIFT+R
|
Launch
Surround With snippet picker
|
CTRL+K,
CTRL+S
|
CTRL+K,
CTRL+S
|
Display
the Code Snippet Manager
|
CTRL+K,
CTRL+B
|
No
equivalent
|
Changes
the IntelliSense filter level from the Common tab to
the All tab.
|
ALT+PLUS
SIGN (+)
|
No
equivalent
|
Changes
the IntelliSense filter level from the All tab to the Common tab.
|
ALT+PERIOD
(.)
|
No
equivalent
|
Document Window and Browser Keyboard
Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Toggle
full-screen mode
|
SHIFT+ALT+ENTER
|
SHIFT+ALT+ENTER
|
Move to
the next pane of a split pane view of a document
|
F6
|
F6
|
Move to
the previous document in the editor or designer
|
CTRL+SHIFT+F6
CTRL+SHIFT+TAB |
CTRL+SHIFT+F6
CTRL+SHIFT+TAB |
Move to
the previous pane of a document in split pane view
|
SHIFT+F6
|
SHIFT+F6
|
Back,
display the previous page in the viewing history
|
ALT+LEFTARROW
|
ALT+LEFTARROW
|
Forward,
display the next page in the viewing history
|
ALT+RIGHTARROW
|
ALT+RIGHTARROW
|
Closes
a menu or dialog box, cancels an operation in progress, or places focus in
the current window
|
ESC
|
No
equivalent
|
Solution Explorer Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Display
Solution Explorer
|
CTRL+ALT+L
|
CTRL+ALT+L
|
Display
the New File dialog box to create a new file
|
CTRL+N
|
CTRL+N
|
Display
the New Project dialog box to create a new project
|
CTRL+SHIFT+N
|
CTRL+SHIFT+N
|
Display
the Open File dialog box to open an existing file
|
CTRL+O
|
CTRL+O
|
Change
the name of the selected object
|
F2
|
No
equivalent
|
Help and Books Online Keyboard
Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Help
|
F1
or SHIFT+F1 |
F1
|
Display
SQL Server Books Online
|
CTRL+F1
|
No
equivalent
|
Open
the Help Library Manager
|
CTRL+ALT+F1
|
No
equivalent
|
Display
the SQL Server Resource Center Web page
|
CTRL+ALT+F2
|
No
equivalent
|
Display
help for the current editor window
|
SHIFT+F1
|
No
equivalent
|
Help on
"How Do I"
|
No
equivalent
|
CTRL+F1
|
Books
Online Contents
|
No
equivalent
|
CTRL+ALT+F1
|
Books
Online Index
|
No
equivalent
|
CTRL+ALT+F2
|
Help
Search
|
No
equivalent
|
CTRL+ALT+F3
|
Dynamic
Help
|
No
equivalent
|
CTRL+ALT+F4
|
Help Favorites
|
No
equivalent
|
CTRL+ALT+F
|
Search Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Display
the Find dialog box
|
CTRL+F
|
CTRL+F
|
Displays
the In Files tab of the Find dialog box.
|
||
Displays
the definition for the selected symbol.
|
F12
|
No
equivalent
|
Displays
the list of references for the selected symbol.
|
SHIFT+F12
|
No
equivalent
|
Display
the Replace dialog box
|
CTRL+H
|
CTRL+H
|
Start
incremental search. Type the characters to search for or press CTRL+I to
search for characters from the previous search
|
CTRL+I
|
CTRL+I
|
Find
the next occurrence of the previous search text
|
F3
|
F3
|
Find
the previous occurrence of the search text
|
SHIFT+F3
|
SHIFT+F3
|
Find
the next occurrence of the currently selected text
|
CTRL+F3
|
CTRL+F3
|
Find
the previous occurrence of the currently selected text
|
CTRL+SHIFT+F3
|
CTRL+SHIFT+F3
|
Display
the Replace in Files dialog box
|
CTRL+SHIFT+H
|
CTRL+SHIFT+H
|
Reverse
incremental search so it starts at the bottom of the file and searches to the
top
|
CTRL+SHIFT+I
|
CTRL+SHIFT+I
|
Select
or clear the Search up option in Find and Replace
|
ALT+F3,
B
|
ALT+F3,
B
|
Stop
the Find in Files search
|
ALT+F3,
S
|
ALT+F3,
S
|
Select
or clear the Find whole word option in Find and
Replace
|
ALT+F3,
W
|
ALT+F3,
W
|
Selects
or clears the Wildcard option in Find and Replace
|
ALT+F3,
P
|
ALT+F3,
P
|
Place
the caret in the Find/Command box of the Standard toolbar
|
CTRL+/
|
No
equivalent
|
Cut and Paste Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Cut
(delete the currently selected item and place it to the Clipboard)
|
CTRL+X
or SHIFTRLT+DELETE |
CTRL+X
or SHIFT+DELETE |
Cuts
all of the selected lines, or the current line if nothing is selected.
|
CTRL+L
or CTRL+SHIFT+L |
No
equivalent
|
Copy to
the Clipboard
|
CTRL+C
or CTRL+INSERT |
CTRL+C
or CTRL+INSERT |
Paste
from the Clipboard at the insertion point
|
CTRL+V
or SHIFT+INSERT |
CTRL+V
or SHIFT+INSERT |
Pastes
an item from the Clipboard Ring at the insertion point and automatically
selects the pasted item
|
CTRL+SHIFT+V
or CTRL+enseSHIFT+INSERT |
No equivalent
|
Log Viewer Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Refresh
|
No
equivalent
|
F5
|
Move
between the Select logs pane and the Log file
summarypane
|
No
equivalent
|
F6
|
Move to
the Log file summary pane
|
No
equivalent
|
ALT+S
|
Load a
new log
|
No
equivalent
|
CTRL+SHIFT+L
|
Export
a log
|
No
equivalent
|
CTRL+SHIFT+E
|
Filter
a log
|
No
equivalent
|
CTRL+SHIFT+F
|
Search
in a log
|
No
equivalent
|
CTRL+SHIFT+S
|
Activity Monitor Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Launches
Activity Monitor
|
CTRLl+ALT+A
|
CTRLl+ALT+A
|
Closes
Activity Monitor
|
CTRL+F4
|
CTRL+F4
|
Refresh
|
F5
|
F5
|
Filter
the monitor display
|
CTRL+SHIFT+F
|
CTRL+SHIFT+F
|
Cycle
through panels
|
F6
|
F6
|
Expand
or collapse selected pane
|
CTRL and
+ or -
|
CTRL
and + or -
|
Expand
or collapse all panes
|
+ or -
|
+ or -
|
Copies
entire selected row in grid
|
CTRL+C
|
CTRL+C
|
Copy
cell
|
CTRL+SHIFT+C
|
CTRL+SHIFT+C
|
Drop-down
for filtering in grid
|
ALT+DOWN
|
ALT+DOWN
|
Scroll
up or down Activity Monitor
|
CTRL+ALT+UP/DOWN
|
CTRL+ALT+UP/DOWN
|
Replication Monitor Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Refresh
|
F5
|
F5
|
Open a
detail window from a grid
|
ENTER
|
ENTER
|
Replication Conflict Viewer Keyboard
Shortcuts
Action
|
SQL
Server 2017
|
SQL Server
2008 R2
|
Define
filter
|
F6
|
F6
|
Apply
filter
|
F7
|
F7
|
Show all
columns
|
F8
|
F8
|
Query Designer Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Cancels
or stops the currently running query
|
CTRL+T
|
CTRL+T
|
Displays
the diagram pane of the Query Designer
|
CTRL+1
|
CTRL+1
|
Displays
the criteria pane of the Query Designer
|
CTRL+2
|
CTRL+2
|
Displays
the SQL pane of the Query Designer
|
CTRL+3
|
CTRL+3
|
Displays
the results pane of the Query Designer
|
CTRL+4
|
CTRL+4
|
Run the
query specified in the Query Designer
|
CTRL+R
|
CTRL+R
|
When in
the results pane, moves focus to the tool strip docked at the bottom of the
designer
|
CTRL+G
|
CTRL+G
|
Enables
JOIN mode in the Query Designer
|
CTRL+SHIFT+J
|
CTRL+SHIFT+J
|
Designer Keyboard Shortcuts
Action
|
SQL
Server 2017
|
SQL
Server 2008 R2
|
Move
the selected control down in increments of 8 on the design surface
|
DOWN
ARROW
|
No
equivalent
|
Move
the selected control left in increments of 8 on the design surface
|
LEFT
ARROW
|
No
equivalent
|
Move
the selected control right in increments of 8 on the design surface
|
RIGHT
ARROW
|
No
equivalent
|
Move
the selected control up in increments of 8 on the design surface
|
UP
ARROW
|
No
equivalent
|
Increases
the height of the selected control in increments of 8
|
SHIFT+DOWN
ARROW
|
No equivalent
|
Reduces
the width of the selected control in increments of 8
|
SHIFT+LEFT
ARROW
|
No equivalent
|
Increases
the width of the selected control in increments of 8
|
SHIFT+RIGHT
ARROW
|
No
equivalent
|
Decreases
the height of the selected control in increments of 8
|
SHIFT+UP
ARROW
|
No
equivalent
|
Moves
to the next control on the page
|
TAB
|
No
equivalent
|
Moves
to the previous control on the page
|
SHIFT+TAB
|
No
equivalent
|
Display
the grid on the design surface
|
ENTER
|
No
equivalent
|
Thanks for your feedback.
ReplyDeleteI appreciate the time you spent finding that information
ReplyDeleteThanks for your feedback
Delete