Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Configure Options > Editor > Code Completion

Code Completion Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set code completion options

  1. Click | Options (ALT+T+O) and select Editor | Code Completion.

  2. Review the following for additional information:

    Statement Completion

    Description

    Auto list members

    Select this checkbox to enable code completion in the editor.

    Default: Selected

    Delay

    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: 500

    Apply 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 (More) at the end of the list to display the additional items.

    Default: Selected

    Exclude column sample data

    Select to exclude—from the primary level in the code completion list—a sample of the first 20 rows of data.

    Clear this checkbox to include the sample data in the primary level of the code completion list.

    Default: Cleared

    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:

   

Related Topics

About Editing SQL

Complete SQL Statements Automatically