Using keyboard shortcuts
Published 11 February 2013
Using keyboard shortcuts to select and insert code suggestions in SQL Prompt can dramatically increase the speed of writing your SQL code. You can use the following keyboard shortcuts:
| Action | Shortcut |
|---|---|
| Switch to/from column picker | Ctrl + Left arrow / Ctrl + Right arrow |
| Move up/down suggestions list | Up arrow / Down arrow |
| Select column in column picker for insertion | Space |
| Move up/down the suggestions box filters | Ctrl + Up arrow / Ctrl + Down arrow |
| Apply format | Ctrl + K + Y (Hold Ctrl and press K then Y) |
Turn on/off code auto-completion (SQL Prompt 5.2 and later) | Ctrl + Shift + P |
Refresh suggestions (SQL Prompt 5.3 only) | Ctrl + Shift + D |
