Share via


SQL Server Management Studio Keyboard Shortcuts

SQL Server Management Studio offers users two keyboard schemes. By default, it uses the SQL Server 2012 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.

Note

To show only the headings, click Collapse All at the top of this page.

Action

SQL Server 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+3

CTRL+3

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+4

CTRL+4

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+5

CTRL+5

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+6

CTRL+6

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+7

CTRL+7

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+7

CTRL+7

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+8

CTRL+8

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+9

CTRL+9

Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog

CTRL+0

CTRL+0

Text Manipulation in Code Editor Keyboard Shortcuts

Action

SQL Server 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

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 2012

SQL Server 2008 R2

Refresh

F5

F5

Open a detail window from a grid

ENTER

ENTER

Replication Conflict Viewer Keyboard Shortcuts

Action

SQL Server 2012

SQL Server 2008 R2

Define filter

F6

F6

Apply filter

F7

F7

Show all columns

F8

F8

Query Designer Keyboard Shortcuts

Action

SQL Server 2012

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 2012

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

See Also

Concepts

Customize Menus and Shortcut Keys