Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL


Looking up tables, columns, and procedures in Interactive SQL

When you enter statements in Interactive SQL, you can use text completion look up the names of tables, columns, or procedures stored in the current database and insert them at your cursor position.


There are no prerequisites for this task.

  1. In Interactive SQL, click Tools, and then choose one of the following:

    Option Action
    Look up table names

    Click Lookup Table Name or press F7.

    Find and select the table.

    Look up column names

    Click Lookup Table Name or press F7.

    Find and select the table containing the column.

    Click Show Columns.

    Look up procedure names

    Click Lookup Procedure Name or press F8.

    Find and select the procedure.

    • Enter the first few characters of a table or procedure name to narrow the list of items.

    • Use the SQL wildcard characters % (percent sign) to match any string of zero or more characters, and '_' (underscore) to match any one character.

    • Search for a wildcard character within a table name by prefixing it with an escape character. The escape character for the SQL Anywhere ODBC driver and SQL Anywhere JDBC driver is ~ (tilde).

  2. Click OK to insert the name into the SQL Statements pane at the current cursor position.


The table, column, or procedure name is found and inserted into the SQL Statements pane.

 See also