Tuesday, October 20, 2009

SQLServer Shortcut Keys





































































































































































































































Shortcut Function
********** ************
ALT+BREAK Cancel a query
ALT+F1 Database object information (Sp_Help)
ALT+F4 Exit
ISQLW To start query analyzer from RUN window
CTRL+B Move the splitter
SQLWb To start management studio from command window
CTRL+D Display results in grid format
CTRL+Delete Delete through the end of the line
CTRL+E Execute query
CTRL+F Find
CTRL+F2 Insert/remove bookmark
CTRL+F4 Disconnect
CTRL+F5 Parse query and check syntax
CTRL+G Go to line
CTRL+H Replace
CTRL+I Index Tuning Wizard
CTRL+K Display/hide execution plan
CTRL+L Display execution plan
CTRL+N New query window
CTRL+O Connect
CTRL+P Print
CTRL+R Show/Hide results pane
CTRL+S Save
CTRL+SHIFT+0 Show options
CTRL+SHIFT+C Comment out code
CTRL+SHIFT+DEL Clear the active Editor pane
CTRL+SHIFT+F Save results to file
CTRL+SHIFT+F2 Clear all bookmarks
CTRL+SHIFT+INSERT Insert a template
CTRL+SHIFT+L Make selection lowercase
CTRL+SHIFT+M Replace template parameters
CTRL+SHIFT+P Open
CTRL+SHIFT+R Remove comment
CTRL+SHIFT+S Show client statistics
CTRL+SHIFT+T Show server trace
CTRL+SHIFT+U Make selection uppercase
CTRL+T Display results in text format
CTRL+U Change database
CTRL+V Paste
CTRL+W Window selector
CTRL+X Delete
CTRL+Z Undo
F1 Help for Query Analyzer
F2 Move to next bookmark
F3 Repeat last search
F4 Object Search
F5 Execute a query
F6 Switch between query and result panes
F8 Show/hide Object Browser
SHIFT+F1 Transact-SQL help
SHIFT+F2 Move to previous bookmark
SHIFT+TAB Decrease indent
SHIFT+F6 Switch panes
TAB Increase indent