Tuesday, 2 December 2014

SQL SERVER QUERY ANALYZER SHORTCUTS : SQL 2005 / 2008


SQL Server Query Analyzer Shortcuts

ShortcutFunctionShortcutFunction
ALT+BREAKCancel a queryCTRL+SHIFT+F2Clear all bookmarks
ALT+F1Database object informationCTRL+SHIFT+INSERTInsert a template
ALT+F4ExitCTRL+SHIFT+LMake selection lowercase
CTRL+ASelect allCTRL+SHIFT+MReplace template parameters
CTRL+BMove the splitterCTRL+SHIFT+POpen
CTRL+CCopyCTRL+SHIFT+RRemove comment
CTRL+DDisplay results in grid formatCTRL+SHIFT+SShow client statistics
CTRL+DeleteDelete through the end of the lineCTRL+SHIFT+TShow server trace
CTRL+EExecute queryCTRL+SHIFT+UMake selection uppercase
CTRL+FFindCTRL+TDisplay results in text format
CTRL+F2Insert/remove bookmarkCTRL+UChange database
CTRL+F4DisconnectCTRL+VPaste
CTRL+F5Parse query and check syntaxCTRL+WWindow selector
CTRL+GGo to lineCTRL+XDelete
CTRL+HReplaceCTRL+ZUndo
CTRL+IIndex Tuning WizardF1Help for Query Analyzer
CTRL+KDisplay/hide execution planF2Move to next bookmark
CTRL+LDisplay execution planF3Repeat last search
CTRL+NNew query windowF4Object Search
CTRL+OConnectF5Execute a query
CTRL+PPrintF6Switch between query and result panes
CTRL+RShow/Hide results paneF8Show/hide Object Browser
CTRL+SSaveSHIFT+F1Transact-SQL help
CTRL+SHIFT+0Show optionsSHIFT+F2Move to previous bookmark
CTRL+SHIFT+CComment out codeSHIFT+TABDecrease indent
CTRL+SHIFT+DELClear the active Editor paneSHIFT+F6Switch panes
CTRL+SHIFT+FSave results to fileTABIncrease indent

0 comments:

Post a Comment