Text completion keyboard shortcuts

The following 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_identifier option. See quoted_identifier 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.