|
The Text Completion 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.