Code Editor Keyboard Shortcuts
Action | SQL Server 2012 | SQL Server 2008 R2 | ||||
Toggle the full-screen display | SHIFT+ALT+ENTER | SHIFT+ALT+ENTER | ||||
Scroll text up one line | CTRL+UP ARROW | CTRL+UP ARROW | ||||
Scroll text down one line | CTRL+DOWN ARROW | CTRL+ DOWN ARROW | ||||
Reverse the last editing action | CTRL+Z or ALT+BACKSPACE | CTRL+Z | ||||
Restore the previously undone edit | CTRL+SHIFT+Z or CTRL+Y | CTRL+SHIFT+Z | ||||
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 | ||||
Open the current file in a browser | CTRL+SHIFT+W | No equivalent | ||||
Delete all text in the current file | CTRL+SHIFT+DEL | CTRL+SHIFT+DEL | ||||
Display the Go To Line dialog box | CTRL+G | CTRL+G | ||||
Display the Navigate To dialog box. | CTRL+PLUS SIGN (+) | No equivalent | ||||
Increase line indent | TAB | TAB | ||||
Decrease line indent | SHIFT+TAB | SHIFT+TAB | ||||
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 | ||||
Open a new query with current connection | CTRL+N | CTRL+N | ||||
Open database in Object Explorer | ALT+F8 | ALT+F8 | ||||
Specify values for template Parameters | CTRL+SHIFT+M | CTRL+SHIFT+M | ||||
Run the selected portion of the query editor or the entire query editor if nothing is selected Parse the selected portion of the query editor or the entire query | F5 or CTRL+SHIFT+E | F5 or CTRL+E or ALT+X | ||||
editor if nothing is selected | CTRL+F5 | CTRL+F5 | ||||
Display the estimated execution plan | CTRL+SHIFT+ALT+L | CTRL+L | ||||
Cancel the executing query | ALT+BREAK | ALT+BREAK | ||||
Include actual execution plan in the query output | CTRL+SHIFT+ALT+M | CTRL+M | ||||
Output results in a grid | CTRL+SHIFT+D | CTRL+D | ||||
Output results in text format | CTRL+T | CTRL+T | ||||
Output results to a file | CTRL+SHIFT+T | CTRL+SHIFT+F | ||||
Show or hide the query results pane | CTRL+R | CTRL+R | ||||
Show the query results pane | CTRL+SHIFT+ALT+R |
| ||||
Toggle between query and results pane | F6 | F6 | ||||
Copy the result grid and headers to the clipboard | CTRL+SHIFT+C | No equivalent | ||||
Move to the next active window in Management Studio | ALT+F6 | ALT+F6 | ||||
Open SQL Server Profiler | CTRL+ALT+P | CTRL+ALT+P | ||||
Display the Query Designer dialog from the query editor window | CTRL+SHIFT+Q | No equivalent | ||||
Run the sp_help system stored Procedure | ALT+F1 | ALT+F1 | ||||
Run the sp_who system stored Procedure | CTRL+1 | CTRL+1 | ||||
Run the sp_lock system stored Procedure | CTRL+2 | CTRL+2 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog | CTRL+3 | CTRL+3 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog | CTRL+4 | CTRL+4 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts Dialog | CTRL+5 | CTRL+5 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog | CTRL+6 | CTRL+6 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts Dialog | CTRL+7 | CTRL+7 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts Dialog | CTRL+7 | CTRL+7 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts Dialog | CTRL+8 | CTRL+8 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog | CTRL+9 | CTRL+9 | ||||
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts Dialog | CTRL+0 | CTRL+0 |
Leave Comment