SQL Document Shortcut Keys

Use the following shortcut keys when working with an SQL document or stored procedure.

Command Name Shortcut Keys Action Where is used
Execute F5 Execute query associated with current document SQL Editor, Query Builder
Execute Current Statement F8 Execute current statement SQL Editor
Previous SQL Ctrl+Shift+Up Arrow Previous SQL statement from history SQL editor
Next SQL Ctrl+Shift+Down Arrow Next SQL statement from history SQL editor
SQL History Ctrl+Alt+H Open SQL History dialog SQL editor
Edit Parameters Ctrl+Shift+P Edit parameters SQL editor
Redirect Data To Output Window Ctrl+Shift+T Show data as text in the Output window SQL editor
List Members CTRL+J List members SQL Editor
List Members CTRL+K, L List members SQL Editor
Complete Word CTRL+SPACE Complete word SQL Editor
Complete Word CTRL+K, W Complete word SQL Editor
Complete Word ALT+Right Arrow Complete word SQL Editor
Parameter Info CTRL+SHIFT+SPACE Parameter information SQL Editor
Parameter Info CTRL+K, P Parameter information SQL Editor
Insert Template CTRL+K, X Insert code template SQL Editor
Insert Template CTRL+K, CTRL+X Insert code template SQL Editor
Quick Info CTRL+K, I Display quick information SQL Editor
Quick Info CTRL+K, CTRL+I Display quick information SQL Editor
Comment Selection CTRL+E, C Comment Selection SQL Editor
Uncomment Selection CTRL+E, U Uncomment selection SQL Editor
Toggle Outlining Expansion CTRL+M, M Toggle outlining expansion SQL Editor
Toggle All Outlining CTRL+M, L Toggle all outlining SQL Editor
Stop Outlining CTRL+M, P Stop outlining SQL Editor
  CTRL+F2 Switch to Navigation Bar SQL Editor
  CTRL+ALT+PGUP Switch from the current document tab to the previous tab SQL Editor
  CTRL+ALT+PGDOWN Switch from the current document tab to the next tab SQL Editor
  CTRL+PLUS SIGN (+) KEY Zoom font size in SQL Editor
  CTRL+MINUS SIGN (-) KEY Zoom font size out SQL Editor
  CTRL+0 Reset font size to the default value SQL Editor
Go To Definition F12 Go to definition SQL Editor
  CTRL+R Hide/Show additional document views SQL Editor
Analyze Code CTRL+K,A Runs T-SQL Analyzer SQL Editor
  CTRL+L Delete current code line and copy it to clipboard SQL Editor
  CTRL+W Close the currently opened tab SQL Editor
  CTRL+N Open a new document tab with inherited server and database of the current document tab SQL Editor

These shortcuts are default shortcuts. All shortcuts can be customized.