CTRL-SHIFT-F2 : Clear all bookmarks. 
CTRL+F2 : Insert or remove a bookmark (toggle). 
F2 : Move to next bookmark. 
SHIFT+F2 : Move to previous bookmark. 
ALT+BREAK : Cancel a query. 
CTRL+O : Connect. 
CTRL+F4 : Disconnect. 
CTRL+F4 : Disconnect and close child window. 
ALT+F1 : Database object information. 
CTRL+SHIFT+DEL : Clear the active Editor pane. 
CTRL+SHIFT+C : Comment out code. 
CTRL+C or Ctrl+Insert : Copy
CTRL+X or Shift+Del : Cut
SHIFT+TAB : Decrease indent. 
CTRL+DEL : Delete through the end of a line in the Editor pane.
CTRL+F : Find. 
CTRL+G : Go to a line number. 
TAB : Increase indent. 
CTRL+SHIFT+L : Make selection lowercase. 
CTRL+SHIFT+U : Make selection uppercase. 
CTRL+V or Shift+Insert : Paste. 
CTRL+SHIFT+R : Remove comments. 
F3 : Repeat last search or find next. 
CTRL+H : Replace. 
CTRL+A : Select all. 
CTRL+Z : Undo. 
F5 or Ctrl + E or ALT+X : Execute a query. 
F1 : Help for Query Analyzer. 
SHIFT+F1 : Help for the selected Transact-SQL statement. 
F6 : Switch between query and result panes. 
Shift+F6 : Switch panes. 
CTRL+W : Window Selector. 
CTRL+N : New Query window. 
F8 : Object Browser (show/hide). 
F4 : Object Search. 
CTRL+F5 : Parse the query and check syntax. 
CTRL+P : Print
CTRL+D : Display results in grid format. 
CTRL+T : Display results in text format. 
CTRL+B : Move the splitter. 
CTRL+SHIFT+F : Save results to file. 
CTRL+R : Show Results pane (toggle).
CTRL+S : Save
CTRL+SHIFT+INSERT : Insert a template. 
CTRL+SHIFT+M : Replace template parameters. 
CTRL+L : Display estimated execution plan. 
CTRL+K : Display execution plan (toggle ON/OFF). 
CTRL+I : Index Tuning Wizard. 
CTRL+SHIFT+S : Show client statistics 
CTRL+SHIFT+T : Show server trace. 
CTRL+U : Use database 
Search this blog
Thursday, June 4, 2009
SQL Server : Query Analyzer Keys
Labels:
SQL,
SQL Server 2008
Subscribe to:
Post Comments (Atom)
 
 
Thanks man., this is very useful info for me
ReplyDelete