.

Wednesday, August 26, 2009

Shortcuts in SQL Query Analyzer

A list of Keyboard Shortcuts in SQL Query Analyzer:
KeyDescriptionKeyDescription
CTRL-SHIFT-F2Clear all bookmarks.CTRL+F2Insert or remove a bookmark (toggle).
F2Move to next bookmark.SHIFT+F2Move to previous bookmark.
ALT+BREAKCancel a query.CTRL+OConnect.
CTRL+F4Disconnect.CTRL+F4Disconnect and close child window.
ALT+F1Database object information.CTRL+SHIFT+DELClear the active Editor pane.
CTRL+SHIFT+CComment out code.CTRL+C or Ctrl+InsertCopy
CTRL+X or Shift+DelCutSHIFT+TABDecrease indent.
CTRL+DELDelete through the end of a line in the Editor pane.CTRL+FFind.
CTRL+GGo to a line number.TABIncrease indent.
CTRL+SHIFT+LMake selection lowercase.CTRL+SHIFT+UMake selection uppercase.
CTRL+V or Shift+InsertPaste.CTRL+SHIFT+RRemove comments.
F3Repeat last search or find next.CTRL+HReplace.
CTRL+ASelect all.CTRL+ZUndo.
F5 or Ctrl + EExecute a query.F1Help for Query Analyzer.
SHIFT+F1Help for the selected Transact-SQL statement.F6Switch between query and result panes.
Shift+F6Switch panes.CTRL+WWindow Selector.
CTRL+NNew Query window.F8Object Browser (show/hide).
F4Object Search.CTRL+F5Parse the query and check syntax.
CTRL+PPrintCTRL+DDisplay results in grid format.
CTRL+TDisplay results in text format.CTRL+BMove the splitter.
CTRL+SHIFT+FSave results to file.CTRL+RShow Results pane (toggle).
CTRL+SHIFT+MReplace template parameters.CTRL+LDisplay estimated execution plan.
CTRL+KDisplay execution plan (toggle ON/OFF).CTRL+IIndex Tuning Wizard.
CTRL+SHIFT+SShow client statisticsCTRL+SHIFT+TShow server trace.
CTRL+UUsedatabase

No comments:

.