Editor tab: Text Completion tab

This tab has the following components:

  • Open Automatically   Select this option if you want the text completion window to open automatically as you type. If you turn off this option, you can still open the text completion window by pressing Ctrl+Space.

  • Complete Automatically   Select this option if you want the text completer to automatically complete the text if there is only one matching item. This option only has an effect when you open the text completion window by pressing Ctrl+Space.

  • Other Options  

    • Show system objects   Select this option if you want system tables and views to appear in the text completion window. When this option is not selected, system tables and views appear only if they are allowed based on the syntax.

    • Show owner names   This option controls whether an object's owner appears along with the object name in the text completion window. 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 non-alphanumeric characters.

    • The Enter key completes text   When this option is selected, pressing Enter completes the text with the item selected in the text completion window. When this option is cleared, pressing Enter inserts a new line into the text editor, but does not complete any text.

 See also