MS SQL Hot Key Shortcuts Print E-mail
Thursday, 29 December 2011 11:55


Alt+F1: sp_help
Alt+X: execute a query
Ctrl+C or Ctrl+X: without selecting anything it will copy/cut the entire row
Ctrl+Shift+Delete: delete all from the current tab
Ctrl+K, K: creates a bookmark
Ctrl+up/down arrow key: scroll
Ctrl+R: show/hide results pane
Ctrl+T: set results to text
Ctrl+D: set results to grid
Ctrl+K, C: comment out the selected text
Ctrl+K, C: uncomment the selected text
Ctrl+N: new query
Alt, Q, C, H: change query connection
Alt, Q, C, C: connect to server
Alt, Q, M: enable/disable SQLCMD mode
Ctrl+Tab: switch between query tabs

Ctrl+F1: sp_helptext

CTR+1 : sp_who
CTRL+2 : sp_lock
Ctrl+3: sp_columns
Ctrl+4: sp_tables
Ctrl+5: sp_stored_procedures
Ctrl+6: sp_helpindex
Ctrl+7: sp_spaceused

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 -- 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.