---
title: "SQL Server Management Studio Keyboard Shortcuts"
ms.custom: seo-lt-2019
ms.date: "03/14/2017"
ms.prod: sql
ms.prod_service: "sql-tools"
ms.reviewer: ""
ms.technology: ssms
ms.topic: conceptual
helpviewer_keywords: 
  - "SQL Server Management Studio [SQL Server], shortcuts"
  - "keyboard shortcuts [SQL Server Management Studio]"
  - "menu shortcuts [SQL Server Management Studio]"
  - "Query Editor [SQL Server Management Studio], keyboard shortcuts"
  - "hot keys [SQL Server Management Studio]"
  - "shortcuts [SQL Server Management Studio], keyboard shortcuts"
  - "keyboard shortcuts [SQL Server Management Studio], list of shortcuts"
  - "shortcuts [SQL Server Management Studio]"
  - "accelerator keys"
ms.assetid: 98baaac4-0727-4ce4-8bfe-c63793ae69b8
author: "markingmyname"
ms.author: "maghan"
---
# SQL Server Management Studio Keyboard Shortcuts

[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../includes/appliesto-ss-asdb-asdw-pdw-md.md)]

[!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)] offers users two keyboard schemes. By default, it uses the [!INCLUDE[ssCurrent](../includes/sscurrent-md.md)] scheme, with keyboard shortcuts based on [!INCLUDE[msCoName](../includes/msconame-md.md)] [!INCLUDE[vsprvs](../includes/vsprvs-md.md)] 2010. [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] also offers a keyboard scheme similar to the standard scheme from [!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]. 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.  
  
## Menu Activation Keyboard Shortcuts  
  
|Action|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|Move to the [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)] 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<br /><br /> or<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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<br /><br /> or<br /><br /> F6 in the [!INCLUDE[ssDE](../includes/ssde-md.md)] 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<br /><br /> or<br /><br /> SHIFT+F6 in the [!INCLUDE[ssDE](../includes/ssde-md.md)] 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<br /><br /> or<br /><br /> 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 ([!INCLUDE[tsql](../includes/tsql-md.md)] Editor only)|CRTL+\\, CTRL+E<br /><br /> or<br /><br /> CTRL+\\, E|CRTL+\\, CTRL+E|  
|Move to the next entry in the Error List window ([!INCLUDE[tsql](../includes/tsql-md.md)] 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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.<br /><br /> If the bookmark is not in a folder, moves to the next bookmark at the same level.<br /><br /> 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.<br /><br /> If the bookmark is not in a folder, moves to the next bookmark at the same level.<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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<br /><br /> or<br /><br /> ALT+BACKSPACE|CTRL+Z|  
|Restore the previously undone edit|CTRL+SHIFT+Z<br /><br /> or<br /><br /> CTRL+Y<br /><br /> or<br /><br /> ALT+SHIFT+BACKSPACE|CTRL+SHIFT+Z<br /><br /> or<br /><br /> CTRL+Y<br /><br /> or<br /><br /> 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<br /><br /> or<br /><br /> CTRL+SHIFT+E|F5<br /><br /> or<br /><br /> CTRL+E<br /><br /> or<br /><br /> 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 [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)]|ALT+F6|ALT+F6|  
|Open [!INCLUDE[ssSqlProfiler](../includes/sssqlprofiler-md.md)]|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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<br /><br /> or<br /><br /> SHIFT+<br /><br /> BACKSPACE|BACKSPACE<br /><br /> or<br /><br /> SHIFT+<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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<br /><br /> or<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|List members|CTRL+J|CTRL+SPACE<br /><br /> or<br /><br /> CTRL+J|  
|Complete word|CTRL+SPACE<br /><br /> or<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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<br /><br /> CTRL+SHIFT+TAB|CTRL+SHIFT+F6<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|Help|F1<br /><br /> or<br /><br /> 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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|Cut (delete the currently selected item and place it to the Clipboard)|CTRL+X<br /><br /> or<br /><br /> SHIFTRLT+DELETE|CTRL+X<br /><br /> or<br /><br /> SHIFT+DELETE|  
|Cuts all of the selected lines, or the current line if nothing is selected.|CTRL+L<br /><br /> or<br /><br /> CTRL+SHIFT+L|No equivalent|  
|Copy to the Clipboard|CTRL+C<br /><br /> or<br /><br /> CTRL+INSERT|CTRL+C<br /><br /> or<br /><br /> CTRL+INSERT|  
|Paste from the Clipboard at the insertion point|CTRL+V<br /><br /> or<br /><br /> SHIFT+INSERT|CTRL+V<br /><br /> or<br /><br /> SHIFT+INSERT|  
|Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item|CTRL+SHIFT+V<br /><br /> or<br /><br /> CTRL+enseSHIFT+INSERT|No equivalent|  
  
## Log Viewer Keyboard Shortcuts  
  
|Action|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|Refresh|F5|F5|  
|Open a detail window from a grid|ENTER|ENTER|  
  
## Replication Conflict Viewer Keyboard Shortcuts  
  
|Action|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|Define filter|F6|F6|  
|Apply filter|F7|F7|  
|Show all columns|F8|F8|  
  
## Query Designer Keyboard Shortcuts  
  
|Action|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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|[!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]|[!INCLUDE[ssKilimanjaro](../includes/sskilimanjaro-md.md)]|  
|------------|-----------------------------|---------------------------------|  
|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  
 [Customize Menus and Shortcut Keys](customize-menus-and-shortcut-keys.md)