Taken from https://www.red-gate.com/simple-talk/sql/sql-training/ssms-the-query-window-keyboard-shortcuts/
|
SSMS |
…Toggle the full-screen display |
Shift+Alt+Enter |
|
… Navigate to |
Cntl+, |
|
|
…Exit |
Alt+F4 |
|
|
Query Window |
…Open with current connection |
Ctrl+Q |
|
…Open with new connection |
Ctrl+N |
|
|
…Save current |
Ctrl+S |
|
|
…Save All |
Ctrl+Shift+S |
|
|
…Close |
Ctrl+F4 |
|
|
|
Ctrl+P |
|
|
…Show or hide the results pane |
Ctrl+R |
|
|
…Toggle query & results pane |
F6 |
|
|
Cycle Clipboard Ring |
Ctrl+shift+V |
|
|
…Move to previous active window |
Ctrl+Shift+F6 |
|
|
…Move to the next active window |
Ctrl+F6 |
|
|
…trace query in SQL Server Profiler |
Ctrl+Alt+P |
|
|
…Open Object Explorer if closed |
F8 |
|
|
…Open Server in Object Explorer |
Alt+F8 |
|
|
…Design Query in Editor |
Ctrl+Shift+Q |
|
|
…Display Go To Line dialog box |
Ctrl+G |
|
|
View |
…Object Explorer |
F8 |
|
…Object Explorer Details |
F7 |
|
|
…Registered Servers |
Ctrl+Alt+G |
|
|
…Template Explorer |
Ctrl+Alt+T |
|
|
…Solution Explorer |
Ctrl+Alt+L |
|
|
…Bookmark Window |
Ctrl+K, Ctri+W |
|
|
…Error List |
Ctrl+V Ctri+E |
|
|
..Output |
CtrkAlt+O |
|
|
…Task List |
Ctrl+Alt+K |
|
|
…Toolbox |
Ctrl+Alt+X |
|
|
…Full Screen |
Shift+Alt+Enter |
|
|
…Navigate Backward |
Ctrl- |
|
|
…Navigate Forward |
Ctrl+Shift+- |
|
|
…Properties Window |
F4 |
|
|
line indent |
…Increase |
TAB |
|
…Decrease |
Shift+TAB |
|
|
Make selected text |
…upper case |
Ctrl+Shift+U |
|
…lower case |
Ctrl+Shift+L |
|
|
…a comment |
Ctrl+K, Ctrl+C |
|
|
…Uncommented |
Ctrl+K, Ctrl+U |
|
|
Specify values |
…for template parameters |
Ctrl+Shift+M |
|
Current Query, selected or all |
…Execute |
F5 (or Ctrl+E) |
|
…Parse |
Ctrl+F5 |
|
|
…Display estimated execution plan |
Ctrl+L |
|
|
…Include Client Statistics |
Shift+Alt+S |
|
|
…Include Actual Execution Plan |
Ctrl+M |
|
|
…Cancel the executing query |
Alt+Break |
|
|
Debugging |
…Start |
Alt+F5 |
|
…Stop |
Shift+F5 |
|
|
..Step Into |
F11 |
|
|
…Step Over |
F10 |
|
|
…Toggle Breakpoint |
F9 |
|
|
…Delete All Breakpoints |
Ctrl+Shift+F9 |
|
|
Output results |
…in a grid |
Ctrl+D |
|
…in text format |
Ctrl+T |
|
|
…to a file |
Ctrl+Shift+F |
|
|
Scroll text |
… up one line |
Ctrl* Up-arrow |
|
… below the cursor |
Ctrl+Shift+Enter |
|
|
Delete |
…all text in the window |
Ctrl+Shift+DEL |
|
…the word to the right of the cursor |
Ctrl+Delete |
|
|
…the word to the left of the cursor |
Ctrl+BACKSPACE |
|
|
Move the cursor |
…to the beginning of the line |
Home |
|
…to the end of the line |
End |
|
|
…the beginning of the document |
Ctrl* Home |
|
|
…to the end of the document |
Ctrl+End |
|
|
…Move the cursor up one screen |
Page Up |
|
|
…Move the cursor down one screen |
Page Down |
|
|
…one word to the right |
Ctrl+Right-arrow |
|
|
…one word to the left |
Ctrl+Left-arrow |
|
|
Select text from the cursor |
…to the beginning of the document |
Ctrl+Shift+Home |
|
… to the end of the document |
Ctrl+Shift+End |
|
|
…to the start of the current line |
Shift+Home |
|
|
…down line by line |
Shift+Down -arrow |
|
|
… up line by line |
Shift+Up-arrow |
|
|
Select |
… the entire current document |
Ctrl+A |
|
… the word containing the cursor, or the closest word |
Ctrl+W |
|
|
… the current location in the editor, back to the previous location in the editor |
Ctrl+= |
|
|
Extend selection |
…to the top of the current window |
Ctrl+Shift+Page Up |
|
… one word to the right |
Ctrl+Shift+Right-arrow |
|
|
… one word to the left |
Ctrl+Shift+Left-arrow |
|
|
… one page up |
Shift+Page Up |
|
|
… one page down |
Shift+Page-Down |
|
|
Move the cursor, Extending the selection |
…To the right one word, |
Ctrl+Shift+Alt+Right-arrow |
|
… to the left one word. |
Ctrl+Shift+Alt+Left-arrow |
|
|
… to the last line in view. |
Ctrl+Shift+Page Down |
|
|
… up one line |
Shift+AIt+Up -arrow |
|
|
…down one line |
Shift+Alt+Down-arrow |
|
|
…Block (column-wise) left |
Alt+Shift +Left-arrow |
|
|
…Block right |
Alt+Shift +Right-arrow |
|
|
…Block up |
Alt +Shift +Up-arrow |
|
|
…Block down |
Alt+Shift +Down-arrow |
|
|
Search for text |
…Display the Find dialog box |
Ctrl+F |
|
…Display the Replace dialog box |
Ctrl+H |
|
|
… the next occurrence of the previous search text |
F3 |
|
|
… the previous occurrence of the search text |
Shift+F3 |
|
|
…the next occurrence of the currently selected text |
Ctrl+F3 |
|
|
… the previous occurrence of the currently selected text |
Ctrl+Shift+F3 |
|
|
(SQL Prompt) Format |
…Rename variables/aliases |
F2 |
|
… Format SQL |
Ctrl+K, Ctrl+Y |
|
|
… Uppercase keywords |
Ctrl+B, Ctrl+U |
|
|
… Expand wildcards |
Ctrl+B, Ctrl+W |
|
|
… Qualify object names |
Ctrl+B, Ctrl+Q |
|
|
… Add/remove square brackets |
Ctrl+B, Ctrl+B |
|
|
… Insert semicolons |
Ctrl+B, Ctrl+C |
|
|
… Encapsulate as new stored procedure |
Ctrl+B, Ctrl+E |
|
|
(SQL Prompt) Navigate |
… Script object as ALTER |
F12 |
|
… Execute current statement |
Shift+F5 |
|
|
… Code Snippets Manager |
Ctrl+K,Ctrl+B |
|
|
… Select in Object Explorer |
Ctrl+F12 |
|
|
… Tab history |
Ctrl+Q |
|
|
… Summarize script |
Ctrl+B, Ctrl+S |
|
|
… Find unused variables and parameters |
Ctrl+B, Ctrl+F |
|
|
(SQL Prompt) Code-Complete |
… Show suggestions |
Ctrl+Space |
|
… Refresh suggestions |
Ctrl+Shift+D |
|
|
… Code suggestions on/off |
Ctrl+Shift+P |
|
|
… Switch to/from column picker |
Ctrl+Left / Ctrl+Right |
|
|
… Move up/down suggestions box filters |
Ctrl+Up / Ctrl+Down |
|
|
Intellisense |
…List members |
Ctrl+Space or Ctrl+J |
|
…Complete word |
Alt+Right Arrow |
|
|
… Parameter Information |
Ctrl+Shift+Space |
|
|
… Refresh Local Cache |
Ctrl+Shift+R |
|
|
… Jump between syntax pairs |
CTRL+] |
|
|
Bookmark |
…go to Next one |
Ctrl+K, Ctrl+N, |
|
…go to previous one |
Ctrl+K, Ctrl+P |
|
|
…Toggle (set or remove) |
Ctrl+K, Ctrl+K |
|
|
… Clear Bookmarks |
Ctrl+K, Ctrl+H |
