Menu
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 –
| Action | SQL Server 2017 | SQL Server 2008 R2 |
|---|---|---|
| Display the Open File dialog box to open an existing file | CTRL+O | CTRL+O |
| or | ||
| CTRL+SHIFT+G | ||
| 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 |
| 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 |
| Reverse the last editing action | CTRL+Z | CTRL+Z |
| or | ||
| ALT+BACKSPACE | ||
| Restore the previously undone edit | CTRL+SHIFT+Z | CTRL+SHIFT+Z |
| or | or | |
| CTRL+Y | CTRL+Y | |
| or | or | |
| ALT+SHIFT+BACKSPACE | ALT+SHIFT+BACKSPACE | |
| Save the selected item | CTRL+S | CTRL+S |
| Save all | CTRL+SHIFT+S | CTRL+SHIFT+S |
| Close | CTRL+F4 | CTRL+F4 |
| CTRL+P | CTRL+P | |
| Exit | ALT+F4 | ALT+F4 |
| Display the Go To Line dialog box | CTRL+G | CTRL+G |
| 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 |
| Show or hide the query results pane | CTRL+R | CTRL+R |
| Refresh local cache | CTRL+SHIFT+R | CTRL+SHIFT+R |
| Display the Find dialog box | CTRL+F | CTRL+F |
| Display the Replace dialog box | CTRL+H | CTRL+H |
| Copy to the Clipboard | CTRL+C | CTRL+C |
| or | or | |
| CTRL+INSERT | CTRL+INSERT | |
| Paste from the Clipboard at the insertion point | CTRL+V | CTRL+V |
| or | or | |
| SHIFT+INSERT | SHIFT+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!