Monday, November 30, 2015

SQL Server Query Analyzer Shortcuts

SQL Server Query Analyzer Shortcuts


ShortcutFunction
ShortcutFunction
ALT+BREAKCancel a query
CTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object information
CTRL+SHIFT+INSERTInsert a template
ALT+F4Exit
CTRL+SHIFT+LMake selection lowercase
CTRL+ASelect all
CTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitter
CTRL+SHIFT+POpen
CTRL+CCopy
CTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid format
CTRL+SHIFT+SShow client statistics
CTRL+DeleteDelete through the end of the line
CTRL+SHIFT+TShow server trace
CTRL+EExecute query
CTRL+SHIFT+UMake selection uppercase
CTRL+FFind
CTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmark
CTRL+UChange database
CTRL+F4Disconnect
CTRL+VPaste
CTRL+F5Parse query and check syntax
CTRL+WWindow selector
CTRL+GGo to line
CTRL+XDelete
CTRL+HReplace
CTRL+ZUndo
CTRL+IIndex Tuning Wizard
F1Help for Query Analyzer
CTRL+KDisplay/hide execution plan
F2Move to next bookmark
CTRL+LDisplay execution plan
F3Repeat last search
CTRL+NNew query window
F4Object Search
CTRL+OConnect
F5Execute a query
CTRL+PPrint
F6Switch between query and result panes
CTRL+RShow/Hide results pane
F8Show/hide Object Browser
CTRL+SSave
SHIFT+F1Transact-SQL help
CTRL+SHIFT+0Show options
SHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out code
SHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor pane
SHIFT+F6Switch panes
CTRL+SHIFT+FSave results to file
TABIncrease indent