SQL Server Management Studio keyboard shortcuts

CTRL+N New Project
CTRL+SHIFT+N Open an existing file
CTRL+O Open an existing project
CTRL+SHIFT+O Add New Item to the current project
CTRL+SHIFT+A Add Existing Item to the current project
ALT+SHIFT+A Display the Query Designer
CTRL+SHIFT+Q Move to the SQL Server Management Studio menu bar
ALT Close a menu or dialog box, canceling the action
ESC Activate the menu for a tool component
ALT+HYPHEN Display the context menu
SHIFT+F1 Clear all bookmarks
CTRL-SHIFT-F2 Insert or remove a bookmark (toggle)
CTRL+F2 Move to next bookmark
F2 Move to previous bookmark
SHIFT+F2 Copy
CTRL+C OR CTRL+INSERT Cut
CTRL+X OR SHIFT+DEL Paste
CTRL+V OR SHIFT+INSERT Make selection lowercase
CTRL+SHIFT+L Make selection uppercase
CTRL+SHIFT+U Select all
CTRL+A Decrease indent
SHIFT+TAB Clear the active Editor pane
CTRL+SHIFT+DEL Delete to end of a line in Editor pane
CTRL+DEL Print
CTRL+P Help for Query Analyzer
F1 Help for the selected Transact-SQL
SHIFT+F1 Switch panes
SHIFT+F6 Window Selector
CTRL+W Object Browser (show/hide)
F8 Object Search
F4 Display results in grid format
CTRL+D Display results in text format
CTRL+T Move the splitter
CTRL+B Show Results pane (toggle)
CTRL+R Insert a template
CTRL+SHIFT+INSERT Replace template parameters
CTRL+SHIFT+M Display estimated execution plan
CTRL+L Display execution plan (toggle ON/OFF)
CTRL+K Index Tuning Wizard
CTRL+I Show client statistics
CTRL+SHIFT+S Show server trace
CTRL+SHIFT+T Disconnect



CTRL+F4 Disconnect and close child window
ALT+F4 Database object information
ALT+F1 Use database
CTRL+U Change Database



CTRL+N Parse the query and check syntax
CTRL+F5 Execute a query
F5 OR CTRL + E Save results to file
CTRL+SHIFT+F Cancel a query
ALT+BREAK Save
CTRL+S Increase indent
TAB Comment - Remove Comment
CTRL+K > U Switch between query and result panes
F6 Comment - Comment Out Code