Use following shortcut keys when working with an SQL document or stored procedure.
Command | Shortcut keys | Action | Where is used |
---|---|---|---|
Execute | F5 | Execute a query associated with the current document | SQL editor |
Previous SQL | Ctrl+Shift+Up Arrow | Previous SQL statement from the history | SQL editor |
Next SQL | Ctrl+Shift+Down Arrow | Next SQL statement from the history | SQL editor |
SQL History | Ctrl+Alt+H | Open the 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/Ctrl+K, L | List members | SQL editor |
Complete Word | Ctrl+Space/Ctrl+K, W/Alt+RightArrow | Complete a word | SQL editor |
Parameter Info | Ctrl+K, P | Parameter information | SQL editor |
Quick Info | Ctrl+K, I/Ctrl+K/Ctrl+I | Display quick information | SQL editor |
Comment Selection | Ctrl+E, C | Comment a selection | SQL editor |
Uncommemt Selection | Ctrl+E, U | Uncomment a 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 |
Switch to Navigation Bar | Ctrl+F2 | Switch to Navigation Bar | SQL editor |
These shortcuts are default shortcuts. All shortcuts can be customized.