Using Text Completion

The text completion option supplies you with complete keywords and object names as you type.

For example, typing the letter S causes a text completion window to appear that includes a list of possible keywords or object names beginning with the letter S. You can configure the text completion settings from the Options window.

  1. Type the first letter of a database object name in the SQL Statements pane.
  2. By default, the text completion window opens automatically as you type. Alternatively, you can press Ctrl+Space or Ctrl+Shift+Space to open the window.
  3. If you do not see the object name you want, press Ctrl+A to view a complete list of database objects (based on the filtering options you set—by default, all database objects appear in the list).
  4. Select the object name from the list and then press Enter.