Useful SQL Server Management Studio Keyboard Shortcuts

   Tweet

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

 

   Tweet