Editor tab:Text Completion tab

This tab has the following components:

What objects do you want in the list?   Select the objects you want to appear in the text completion window. By default, the names of all database objects appear in the text completion list.

  • Tables and views   Select this option if you want tables and views to appear in the text completion list.

  • Columns   Select this option if you want columns to appear in the text completion list.

  • Stored procedures   Select this option if you want stored procedures to appear in the text completion list.

  • SQL functions   Select this option if you want built-in SQL functions to appear in the text completion list.

Show system objects   Select this option if you want system objects to appear in the text completion list.

Show owner names   This option controls whether an object's owner is displayed in the list of objects. It does not control whether the owner name appears in the completed text.

Show tool tips   Select this option if you want tool tips to appear in the text completion window.

Quote identifiers   Select this option if you want identifiers to be enclosed in double quotes. Identifiers must be enclosed in double quotes if any of the following conditions are true:

  • The identifier contains spaces.

  • The first character of the identifier is not an alphabetic character.

  • The identifier contains a reserved word.

  • The identifier contains characters other than alphabetic characters and digits.

    See Identifiers.

Automatically complete text   Select this option if you want identifier names to be completed automatically, so long as there is only one match. If multiple identifiers match the text you type, a list appears where you can choose the identifier you want.

See also