To set code completion options
Select Tools | Options |Editor | Code Completion.
Review the following for additional information:
|
Code Completion |
Description |
|
Auto pop-up after |
Enter the number of milliseconds that you want to elapse before the list automatically displays in the editor after you press PERIOD after an object. Default: 250 |
|
Apply Object Explorer filters |
Select this checkbox to apply any filters set in the Database Explorer/Object Explorer to the code completion list in the editor. Default: Cleared |
|
Item sort order |
Select the method used for sorting the code completion list. If you select Each category, Toad sorts the list based on the type of item. For example, if you enter SELECT in the statement, the list displays columns first followed by variables, snippets, etc. Default: Each category |
|
Quoting |
Select whether to add quotes to any item selected from a code completion list. Default: Only if needed |
|
Expand "*" to list all columns |
Select this checkbox to add an asterisk as the first entry in the code completion list for columns. If you select the asterisk, all columns for the table are added to the list. Default: Selected |
|
Include rarely used items |
Select this checkbox to include less common items in the code completion list. If cleared, only the common items display in the list and you must select (Show rarely used items) at the end of the list to display the additional items. Default: Selected |
|
Include top <n> values of column data |
Select this checkbox to include a sample of the first 20 rows of data from the primary level in the code completion list. Clear this checkbox to exclude the sample data in the primary level of the code completion list. Default: Selected |
|
Insert default schema name |
Select this checkbox to insert schema names in front of the objects with default owner. Default: Cleared |
| Show Code Completion on Boolean Field | Select this checkbox to see the code completion suggestions for boolean fields. Clear this checkbox to hide the code completion suggestions for boolean fields. Default: Selected |
|
Locator Beacon |
Description |
|
Duration |
Enter the amount of time an indicator displays over parameters/variables that require a value. |
|
Code Snippets |
Description |
|
Root folder |
Select the folder where you want to store code snippets. This is useful if you want to specify a network directory with custom snippets shared by all developers. Create TOADSQLFILE.sql in the root folder in order to use it's contents as template when opening new Editor window. Tip: Constructions surrounded with $ (for example, $Name$) are treated as snippets. |
|
Favorites folder |
To change the name of the Favorites folder, enter a new name. This will change the name of the Favorites folder for each SQL language. |
Tips:
To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).
To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. See About Options for more information.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
