Content Assist presents a list of available syntax options when
you edit SQL statements in SQL File Editor.
The list of options includes SQL language keywords, table names, table
column names, built-in database functions and types, and local variables. You
can access this list from your current cursor position. Based on the context of
the current SQL syntax rules, the list filters syntax options no longer
available to you as you enter SQL code.
There are two ways to invoke
Content Assist.
Invocation method
|
Description
|
Manual invocation
|
By default, invoke
Content Assist using the key sequence
Ctrl+Space
. You
can customize the key sequence by modifying the Text Editors preferences.
|
Auto-invocation
|
Pausing after typing the following
characters displays the
Content Assist options list:
-
A table name followed by a period lists the column
names of the table.
-
A database name followed by two periods lists all
the available table names in the database. For example, 'pubs2..'.
-
'@' displays a list of all in-scope local variables or
parameters.
|