Tuesday, 5 January 2016

SQL Server Management Studio Keyboard Shortcuts

SQL Server Management Studio offers users two keyboard schemes. By default, it uses the SQL Server 2016 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 theEnvironmentKeyboard page.
System_CAPS_noteNote
To show only the headings, click Collapse All at the top of this page.

Menu Activation Keyboard Shortcuts

Action
SQL Server 2016
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
or
CTRL+SHIFT+G
CTRL+O
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, canceling the action
ESC
ESC

Windows Management and Toolbar Keyboard Shortcuts

Action
SQL Server 2016
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
or
F6 in the Database Engine Query Editor
ALT+F6
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
or
SHIFT+F6 in the Database Engine Query Editor
SHIFT+ALT+F6
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
or
CTRL+\, CTRL+T
CTRL+ALT+K
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
or
CTRL+\, E
CRTL+\, 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 2016
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 2016
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 2016
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
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+N
No equivalent
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 2016
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

Code Editor Keyboard Shortcuts

All shortcuts are not implemented in all types of code editors.
Action
SQL Server 2016
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
or
ALT+BACKSPACE
CTRL+Z
Restore the previously undone edit
CTRL+SHIFT+Z
or
CTRL+Y
or
ALT+SHIFT+BACKSPACE
CTRL+SHIFT+Z
or
CTRL+Y
or
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
or
CTRL+SHIFT+E
F5
or
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 ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+3
CTRL+3
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+4
CTRL+4
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+5
CTRL+5
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+6
CTRL+6
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+7
CTRL+7
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+7
CTRL+7
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+8
CTRL+8
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+9
CTRL+9
Run the stored procedure configured for this shortcut in the ToolsOptionsKeyboard,Query Shortcuts dialog
CTRL+0
CTRL+0

Text Manipulation in Code Editor Keyboard Shortcuts

Action
SQL Server 2016
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

Transact-SQL Debugger Keyboard Shortcuts

Action
SQL Server 2016
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 Breakpoints window
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 2016
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 2016
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 2016
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 2016
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 2016
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 2016
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 2016
SQL Server 2008 R2
Refresh
No equivalent
F5
Move between the Select logs pane and the Log file summary pane
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 2016
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 2016
SQL Server 2008 R2
Refresh
F5
F5
Open a detail window from a grid
ENTER
ENTER

Replication Conflict Viewer Keyboard Shortcuts

Action
SQL Server 2016
SQL Server 2008 R2
Define filter
F6
F6
Apply filter
F7
F7
Show all columns
F8
F8

Query Designer Keyboard Shortcuts

Action
SQL Server 2016
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 2016
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