Using text completion

Interactive SQL and Sybase Central provide a text completion option that can supply 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 in Interactive SQL or a text editor window in Sybase Central.

 Use text completion

  1. In Interactive SQL, 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. The text completion window contains a list of database objects that begin with the letter(s) you typed. In the following example, the text completion window shows all database objects beginning with the letter F.

    Text completion options for database objects that begin with the letter F.

    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).

  3. Select the object name from the list and then press Enter.

    The object name appears in the SQL Statements pane.

Text completion keyboard shortcuts

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1