Keyboard shortcuts are available when the text completion list is open.
| Key | Description |
|---|---|
Ctrl+A |
Shows a context-free list of matches. |
Ctrl+Double quote (") (or Ctrl+Shift+') |
Completes the name, enclosing it in quotation marks, regardless of the setting of the quoted_indentifier option. |
Ctrl+Asterisk (*) (or Ctrl+Shift+8) |
For tables, inserts a comma-separated list of columns including data types. For stored procedures, inserts the procedure name, followed by a comma-separated list of parameter names and their data types. |
Ctrl+C |
Changes the contents of the text completion list to show or hide columns. |
Ctrl+F |
Changes the contents of the text completion list to show or hide SQL functions. |
Ctrl+P |
Changes the contents of the text completion list to show or hide stored procedures and functions. |
Ctrl+Plus Sign (+) (or Ctrl+Shift+=) |
For tables, inserts a comma-separated list of columns. For stored procedures, inserts the procedure name, followed by a comma-separated list of parameter names. |
Ctrl+S |
Changes the contents of the text completion list to show or hide system objects. |
Ctrl+Shift+Space or Ctrl+Space |
Opens the text completion window. You can also use Ctrl+Space to open the text completion window. |
Ctrl+T |
Changes the contents of the text completion list to show or hide tables. |
Ctrl+V |
Changes the contents of the text completion list to show or hide views. |
Esc |
Closes the text completion window without adding any text. |
Tab |
Accepts the selection and closes the text completion window. |