The Content Assist feature of SQL Editor presents a list of available syntax options while you are editing SQL statements. The list includes SQL language keywords, table names, table column names, built-in database functions and types, and local variables, among other syntax. You can access this list from your current cursor position. Based on the context of the current SQL syntax rules, the list filters out syntax options no longer available to you as you enter SQL code. You select the available option to be used by either double-clicking the item or by navigating the list using the up or down arrow key until you reach the preferred item and then press Enter.
There are two ways to invoke Content Assist:
Manual invocation: By default, this method uses the Eclipse Content Assist key sequence Ctrl+Space. You can customize the key sequence by modifying Eclipse preferences.
Select Windows|Preferences. The Preferences dialog appears.
Select General|Keys, and in the Keys dialog click the Modify tab.
In the Command section, choose Edit from the Category drop-down menu and Content Assist from the Name drop-down menu.
The default values are displayed.
Enter a key sequence in the Name field in the Key Sequence section.
Click Apply or OK.
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 that database. For example, 'pubs2..'.
'@' displays a list of all in-scope local variables or parameters.
To change autoactivation settings and other content assist options, set SQL Editor|Code Assist preferences.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com