Code Assist Preferences

SQL Editor Code Assist preferences define the behavior of the Code Assist feature in SQL File Editor.

Table 1. Code Assist preferences: General
Field Explanation
Insert Single Proposals Automatically insert single proposals (default).
Show System Tables Display system tables when applicable.
Show System Views Display system views when applicable.
Show System Procedures and Functions Display system procedures and functions when applicable.
Show Owner of Table or View Display the owner.
Enable Auto Activation Invoke Code Assist automatically (default).

You can set:


  • Auto activation delay
  • Auto activation triggers for SQL
Auto Activation Delay Specify the time in milliseconds that must elapse after you type a character before Code Assist is automatically invoked. Default is 500.

When you enter a character and pause before entering another character, Code Assist automatically displays a menu of keywords you can select to complete the SQL statement.

Auto Activation Triggers for SQL Enter characters that automatically activate Code Assist. Enter characters in any order with no separator character.

When you type these characters, the Code Assist menu displays after the Auto activation delay unless you enter another character.

Table 2. Code Assist preferences: Sybase
Field Explanation
Show Proxy Tables Display proxy tables when applicable.
Related tasks
Developing a SQL File
Related reference
SQL Editor Preferences
SQL Files/Scrapbooks
Templates Preferences

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com