SSMS Shortcuts

By Lori Brown | SQL Development

May 17

Thought I would post some quick helpful things like shortcuts in SSMS. There is a link to a comprehensive list of keyboard shortcuts for SSMS at the end of this post. There is more than just ctrl-c & crtl-v out there!!

Here are my fav’s –

ActionSQL Server 2017SQL Server 2008 R2
Display the Open File dialog box to open an existing fileCTRL+OCTRL+O
or
CTRL+SHIFT+G
Move the cursor to the end of the lineENDEND
Move the cursor to the beginning of the documentCTRL+HOMECTRL+HOME
Move the cursor to the end of the documentCTRL+ENDCTRL+END
Select text from the cursor to the beginning of the documentCTRL+SHIFT+ HOMECTRL+SHIFT+ HOME
Select text from the cursor to the end of the documentCTRL+SHIFT+ENDCTRL+SHIFT+END
Reverse the last editing actionCTRL+ZCTRL+Z
or
ALT+BACKSPACE
Restore the previously undone editCTRL+SHIFT+ZCTRL+SHIFT+Z
oror
CTRL+YCTRL+Y
oror
ALT+SHIFT+BACKSPACEALT+SHIFT+BACKSPACE
Save the selected itemCTRL+SCTRL+S
Save allCTRL+SHIFT+SCTRL+SHIFT+S
CloseCTRL+F4CTRL+F4
PrintCTRL+PCTRL+P
ExitALT+F4ALT+F4
Display the Go To Line dialog boxCTRL+GCTRL+G
Make the selected text upper caseCTRL+SHIFT+UCTRL+SHIFT+U
Make the selected text lower caseCTRL+UCTRL+SHIFT+L
Make the selected text a commentCTRL+K, CTRL+CCTRL+K, CTRL+C
Uncomment the selected textCTRL+K, CTRL + UCTRL+K, CTRL + U
Show or hide the query results paneCTRL+RCTRL+R
Refresh local cacheCTRL+SHIFT+RCTRL+SHIFT+R
Display the Find dialog boxCTRL+FCTRL+F
Display the Replace dialog boxCTRL+HCTRL+H
Copy to the ClipboardCTRL+CCTRL+C
oror
CTRL+INSERTCTRL+INSERT
Paste from the Clipboard at the insertion pointCTRL+VCTRL+V
oror
SHIFT+INSERTSHIFT+INSERT

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts

For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at SQLRx@sqlrx.com. We will be happy to help! Leave a comment and feel free to track back to us. We love to talk tech with anyone in our SQL family!

>