{"id":1155,"date":"2011-06-10T00:00:00","date_gmt":"2011-06-10T00:00:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/ssms-the-query-window-keyboard-shortcuts\/"},"modified":"2021-05-11T15:57:34","modified_gmt":"2021-05-11T15:57:34","slug":"ssms-the-query-window-keyboard-shortcuts","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/tools-sql-server\/ssms-the-query-window-keyboard-shortcuts\/","title":{"rendered":"SSMS: The Query Window Keyboard Shortcuts"},"content":{"rendered":"<div id=\"pretty\">\n<p class=\"start\">The Keyboard shortcuts that are displayed in the wall-chart are based on what is on Books-on-line, but reordered and grouped in such a way as to make it easier to find what you&#8217;re looking for. We&#8217;ve also taken out a lot of the keystrokes for navigating rapidly between various parts of SSMS that aren&#8217;t related to the query windows, since this was intended more for the SQL developer. We added the SQL Prompt keys since SQL Prompt is so widely used.<\/p>\n<p>The Wallchart is available at the bottom of the article as a PDF.<\/p>\n<table class=\"MsoNormalTable table--tight\" border=\"0\" width=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr style=\"border-top: 1px silver;\">\n<td rowspan=\"3\" valign=\"top\">\n<p><b>SSMS<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Toggle the full-screen display<\/p>\n<\/td>\n<td>\n<p>Shift+Alt+Enter<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Navigate to<\/p>\n<\/td>\n<td>\n<p>Cntl+,<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Exit<\/p>\n<\/td>\n<td>\n<p>Alt+F4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"16\" valign=\"top\">\n<p><b>Query Window<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Open with current connection<\/p>\n<\/td>\n<td>\n<p>Ctrl+Q<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Open with new connection<\/p>\n<\/td>\n<td>\n<p>Ctrl+N<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Save current<\/p>\n<\/td>\n<td>\n<p>Ctrl+S<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Save All<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+S<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Close<\/p>\n<\/td>\n<td>\n<p>Ctrl+F4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Print<\/p>\n<\/td>\n<td>\n<p>Ctrl+P<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Show or hide the results pane<\/p>\n<\/td>\n<td>\n<p>Ctrl+R<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Toggle query &amp; results pane<\/p>\n<\/td>\n<td>\n<p>F6<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>Cycle Clipboard Ring<\/p>\n<\/td>\n<td>\n<p>Ctrl+shift+V<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Move to previous active window<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+F6<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Move to the next active window<\/p>\n<\/td>\n<td>\n<p>Ctrl+F6<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026trace query in SQL Server Profiler<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+P<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Open Object Explorer if closed<\/p>\n<\/td>\n<td>\n<p>F8<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Open Server in Object Explorer<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>Alt+F8<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Design Query in Editor<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>Ctrl+Shift+Q<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Display Go To Line dialog box<\/p>\n<\/td>\n<td>\n<p>Ctrl+G<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"14\" valign=\"top\">\n<p><b>View<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Object Explorer<\/p>\n<\/td>\n<td>\n<p>F8<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Object Explorer Details<\/p>\n<\/td>\n<td>\n<p>F7<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Registered Servers<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+G<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Template Explorer<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+T<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Solution Explorer<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+L<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Bookmark Window<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctri+W<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Error List<\/p>\n<\/td>\n<td>\n<p>Ctrl+V Ctri+E<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>..Output<\/p>\n<\/td>\n<td>\n<p>CtrkAlt+O<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Task List<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+K<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Toolbox<\/p>\n<\/td>\n<td>\n<p>Ctrl+Alt+X<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Full Screen<\/p>\n<\/td>\n<td>\n<p>Shift+Alt+Enter<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Navigate Backward<\/p>\n<\/td>\n<td>\n<p>Ctrl-<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Navigate Forward<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+-<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Properties Window<\/p>\n<\/td>\n<td>\n<p>F4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" valign=\"top\">\n<p><b>line indent<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Increase<\/p>\n<\/td>\n<td>\n<p>TAB<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Decrease<\/p>\n<\/td>\n<td>\n<p>Shift+TAB<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"4\" valign=\"top\">\n<p><b>Make selected text<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026upper case<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+U<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026lower case<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+L<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026a comment<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+C<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Uncommented<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+U<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">\n<p><b>Specify values<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026for template parameters<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+M<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"6\" valign=\"top\">\n<p><b>Current Query, selected or all<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Execute<\/p>\n<\/td>\n<td>\n<p>F5 (or Ctrl+E)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Parse<\/p>\n<\/td>\n<td>\n<p>Ctrl+F5<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Display estimated execution plan<\/p>\n<\/td>\n<td>\n<p>Ctrl+L<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Include Client Statistics<\/p>\n<\/td>\n<td>\n<p>Shift+Alt+S<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Include Actual Execution Plan<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>Ctrl+M<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Cancel the executing query<\/p>\n<\/td>\n<td>\n<p>Alt+Break<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"6\" valign=\"top\" nowrap=\"nowrap\">\n<p><b>Debugging<\/b><\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Start<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u00a0Alt+F5<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Stop<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u00a0Shift+F5<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>..Step Into<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u00a0F11<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Step Over<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u00a0F10<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Toggle Breakpoint<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u00a0F9<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>\u2026Delete All Breakpoints<\/p>\n<\/td>\n<td valign=\"bottom\" nowrap=\"nowrap\">\n<p>Ctrl+Shift+F9<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" valign=\"top\">\n<p><b>Output results<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026in a grid<\/p>\n<\/td>\n<td>\n<p>Ctrl+D<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026in text format<\/p>\n<\/td>\n<td>\n<p>Ctrl+T<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026to a file<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+F<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"2\" valign=\"top\">\n<p><b>Scroll text<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026 up one line<\/p>\n<\/td>\n<td>\n<p>Ctrl* Up-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 below the cursor<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Enter<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" valign=\"top\">\n<p><b>Delete<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026all text in the window<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+DEL<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026the word to the right of the cursor<\/p>\n<\/td>\n<td>\n<p>Ctrl+Delete<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026the word to the left of the cursor<\/p>\n<\/td>\n<td>\n<p>Ctrl+BACKSPACE<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"8\" valign=\"top\">\n<p><b>Move the cursor<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026to the beginning of the line<\/p>\n<\/td>\n<td>\n<p>Home<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026to the end of the line<\/p>\n<\/td>\n<td>\n<p>End<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026the beginning of the document<\/p>\n<\/td>\n<td>\n<p>Ctrl* Home<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026to the end of the document<\/p>\n<\/td>\n<td>\n<p>Ctrl+End<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Move the cursor up one screen<\/p>\n<\/td>\n<td>\n<p>Page Up<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Move the cursor down one screen<\/p>\n<\/td>\n<td>\n<p>Page Down<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026one word to the right<\/p>\n<\/td>\n<td>\n<p>Ctrl+Right-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026one word to the left<\/p>\n<\/td>\n<td>\n<p>Ctrl+Left-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"5\" valign=\"top\">\n<p><b>Select text from the cursor<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026to the beginning of the document<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Home<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 to the end of the document<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+End<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026to the start of the current line<\/p>\n<\/td>\n<td>\n<p>Shift+Home<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026down line by line<\/p>\n<\/td>\n<td>\n<p>Shift+Down -arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 up line by line<\/p>\n<\/td>\n<td>\n<p>Shift+Up-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"3\" valign=\"top\">\n<p><b>Select<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026 the entire current document<\/p>\n<\/td>\n<td>\n<p>Ctrl+A<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 the word containing the cursor, or the closest word<\/p>\n<\/td>\n<td>\n<p>Ctrl+W<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 the current location in the editor, back to the previous location in the editor<\/p>\n<\/td>\n<td>\n<p>Ctrl+=<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"5\" valign=\"top\">\n<p><b>Extend selection<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026to the top of the current window<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Page Up<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 one word to the right<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Right-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 one word to the left<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Left-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 one page up<\/p>\n<\/td>\n<td>\n<p>Shift+Page Up<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 one page down<\/p>\n<\/td>\n<td>\n<p>Shift+Page-Down<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"9\" valign=\"top\">\n<p><b>Move the cursor, Extending the selection<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026To the right one word,<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Alt+Right-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 to the left one word.<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Alt+Left-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 to the last line in view.<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Page Down<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 up one line<\/p>\n<\/td>\n<td>\n<p>Shift+AIt+Up -arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026down one line<\/p>\n<\/td>\n<td>\n<p>Shift+Alt+Down-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Block (column-wise) left<\/p>\n<\/td>\n<td>\n<p>Alt+Shift +Left-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Block right<\/p>\n<\/td>\n<td>\n<p>Alt+Shift +Right-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Block up<\/p>\n<\/td>\n<td>\n<p>Alt +Shift +Up-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Block down<\/p>\n<\/td>\n<td>\n<p>Alt+Shift +Down-arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"6\" valign=\"top\">\n<p><b>Search for text<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Display the Find dialog box<\/p>\n<\/td>\n<td>\n<p>Ctrl+F<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Display the Replace dialog box<\/p>\n<\/td>\n<td>\n<p>Ctrl+H<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 the next occurrence of the previous search text<\/p>\n<\/td>\n<td>\n<p>F3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 the previous occurrence of the search text<\/p>\n<\/td>\n<td>\n<p>Shift+F3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026the next occurrence of the currently selected text<\/p>\n<\/td>\n<td>\n<p>Ctrl+F3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 the previous occurrence of the currently selected text<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+F3<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"8\" valign=\"top\">\n<p><b>(SQL Prompt) Format<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026Rename variables\/aliases<\/p>\n<\/td>\n<td>\n<p>F2<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Format SQL<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+Y<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Uppercase keywords<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+U<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Expand wildcards<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+W<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Qualify object names<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+Q<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Add\/remove square brackets<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+B<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Insert semicolons<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+C<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Encapsulate as new stored procedure<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+E<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"7\" valign=\"top\">\n<p><b>(SQL Prompt) Navigate<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026 Script object as ALTER<\/p>\n<\/td>\n<td>\n<p>F12<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Execute current statement<\/p>\n<\/td>\n<td>\n<p>Shift+F5<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Code Snippets Manager<\/p>\n<\/td>\n<td>\n<p>Ctrl+K,Ctrl+B<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Select in Object Explorer<\/p>\n<\/td>\n<td>\n<p>Ctrl+F12<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Tab history<\/p>\n<\/td>\n<td>\n<p>Ctrl+Q<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Summarize script<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+S<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Find unused variables and parameters<\/p>\n<\/td>\n<td>\n<p>Ctrl+B, Ctrl+F<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"5\" valign=\"top\">\n<p><b>(SQL Prompt) Code-Complete<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026 Show suggestions<\/p>\n<\/td>\n<td>\n<p>Ctrl+Space<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Refresh suggestions<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+D<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Code suggestions on\/off<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+P<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Switch to\/from column picker<\/p>\n<\/td>\n<td>\n<p>Ctrl+Left \/ Ctrl+Right<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Move up\/down suggestions box filters<\/p>\n<\/td>\n<td>\n<p>Ctrl+Up \/ Ctrl+Down<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"5\" valign=\"top\">\n<p><b>Intellisense<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026List members<\/p>\n<\/td>\n<td>\n<p>Ctrl+Space or Ctrl+J<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Complete word<\/p>\n<\/td>\n<td>\n<p>Alt+Right Arrow<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Parameter Information<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+Space<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Refresh Local Cache<\/p>\n<\/td>\n<td>\n<p>Ctrl+Shift+R<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Jump between syntax pairs<\/p>\n<\/td>\n<td>\n<p>CTRL+]<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td rowspan=\"4\" valign=\"top\">\n<p><b>Bookmark<\/b><\/p>\n<\/td>\n<td>\n<p>\u2026go to Next one<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+N,<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026go to previous one<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+P<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026Toggle (set or remove)<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+K<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p>\u2026 Clear Bookmarks<\/p>\n<\/td>\n<td>\n<p>Ctrl+K, Ctrl+H<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Simple-Talk&#8217;s free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries.  <\/p>\n<p>&hellip;<\/p>\n","protected":false},"author":9580,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143532],"tags":[4178,4150,4151,5347],"coauthors":[11318],"class_list":["post-1155","post","type-post","status-publish","format-standard","hentry","category-tools-sql-server","tag-bi","tag-sql","tag-sql-server","tag-sql-training"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/1155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/9580"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=1155"}],"version-history":[{"count":9,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/1155\/revisions"}],"predecessor-version":[{"id":71892,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/1155\/revisions\/71892"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=1155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=1155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=1155"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=1155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}