Setting Candidate List Behavior

You can set the behavior of the candidate list, for example to display only objects for the owner (or schema) you have specified, or set the completion keys that will insert candidates in your query editor.

To set the behavior of the candidate list, on the SQL Prompt menu in your query editor, click Options, and then click the Candidates tab.

To reset the options on the Candidates tab to their default values, click Restore Defaults.

Completion Keys

Completion keys enable you to insert the selected candidate in your query editor.

You can select the following completion keys:

Enter
Tab
Spacebar
Dot ( . )
Comma ( , )
Closing bracket ( ] )
Parentheses ( )

Join Conditions

By default, SQL Prompt suggests columns for join conditions based on foreign key relationships for all the tables you have specified in the query.

SQL Prompt also suggests join conditions based on column names that are an exact match (ignoring case). If you do not want SQL Prompt to do this, under Join Conditions, clear the Include matching column names check box.

To display join conditions for columns with matching data types, under Join Conditions, select the Include matching data types option.

Candidate Ordering

To apply case-sensitive sort order to the candidate list, under Candidate Ordering, select the Apply case-sensitive sort order check box. When this check box is selected, uppercase items take precedence over lowercase items. For example, the items Staff, stock, and Store will not be listed together; stock will be listed with other lowercase items.

Note that you are recommended to keep this option cleared for large databases.

Owner or Schema Filtering

When you specify an owner (or schema), the candidate list displays only objects that belong to that owner (or schema). For example, when you type SELECT orders. the candidate list will display only objects that are owned by orders.

To turn off owner (or schema) filtering, under Owner or Schema Filtering, clear the Show objects for specified owner or schema check box. If you are experiencing performance or resource usage problems, and you are using large databases, you are recommended to clear this option.

Other Objects

By default, the candidate list displays variables. If you do not want SQL Prompt to display variables in the candidate list, under Other Objects, clear the Include variables in the candidate list check box. You are recommended to clear this option for large databases.

To display system objects in the candidate list, select the Include system objects in the candidate list check box.