Please find some useful keyword shortcuts available in Microsoft SQL Server Management Studio that would help to improve your productivity on the thing done frequently.
| Action |
KeyBoard ShortCut |
| Display the context menu/mouse Right Click |
SHIFT+F10 |
| Display the New File dialog box to create a file |
CTRL+N |
| Display the Query Designer |
CTRL+SHIFT+Q |
| Toggle full screen mode |
SHIFT+ALT+ENTER |
| Scroll text up one line |
CTRL+UP ARROW |
| Scroll text down one line |
CTRL+DOWN ARROW |
| Reverse the last editing action |
CTRL+Z |
| Restore the previously undone edit |
CTRL+SHIFT+Z or ALT+SHIFT+BACKSPACE or CTRL+Y |
| Save all |
CTRL+SHIFT+S |
| Delete all text in the current file |
CTRL+SHIFT+DEL |
| Display the Go To Line dialog box |
CTRL+G |
| Increase line indent |
TAB |
| Decrease line indent |
SHIFT+TAB |
| Make the selected text upper case |
CTRL+SHIFT+U |
| Make the selected text lower case |
CTRL+SHIFT+L |
| Make the selected text a comment |
CTRL+K, CTRL+C |
| Uncomment the selected text |
CTRL+K, CTRL + U |
| Open a new query with current connection |
CTRL+Q |
| Execute the selected portion of the query editor or the entire query editor if nothing is selected |
F5 or CTRL+E or ALT+X |
| Display the estimated execution plan |
CTRL+L |
| Cancel the executing query |
ALT+BREAK |
| Include actual execution plan in the query output |
CTRL+M |
| Output results in a grid |
CTRL+D |
| Output results in text format |
CTRL+T |
| Output results to a file |
CTRL+SHIFT+F |
| Show or hide the query results pane |
CTRL+R |
| Toggle between query and results pane |
F6 |
| Move to the next active window in Management Studio |
CTRL+F6 |
| Display the Find dialog box |
CTRL+F |
| Display the Replace dialog box |
CTRL+H |
| Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search |
CTRL+I |
| Find the next occurrence of the previous search text |
F3 |
| Find the previous occurrence of the search text |
SHIFT+F3 |
| Find the next occurrence of the currently selected text |
CTRL+F3 |
| Find the previous occurrence of the currently selected text |
CTRL+SHIFT+F3 |
| Display the Replace in Files dialog box |
CTRL+SHIFT+H |
| Reverse incremental search so it starts at the bottom of the file and searches to the top |
CTRL+SHIFT+I |
| Select or clear the Search up option in Find and Replace |
ALT+F3, B |
| Stop the Find in Files search |
ALT+F3, S |
| Select or clear the Find whole word option in Find and Replace |
ALT+F3, W |
| Selects or clears the Wildcard option in Find and Replace |
ALT+F3, P |
