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!

Follow

About the Author

Lori is an avid runner, cyclist and SQL enthusiast. She has been working for SQLRX for 10 years and has been working with SQL in general for 20 years. Yup...she is an old hand at this stuff.

>