# 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).
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 concepts
SQL File Editor
SQL Scrapbook
Related tasks
Creating a SQL File
Editing a SQL File
Opening a SQL File
Saving a SQL File
Executing a SQL File
Related reference
SQL Editor Preferences
SQL Files/Scrapbooks Preferences
Syntax Coloring Preferences
Templates Preferences