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 - SQL Usage » Queries and data modification » Joins: Retrieving data from several tables


Displaying a list of tables

You can view all the tables, as well as their columns, of the database you are connected to from Interactive SQL.


You must be connected to the database.

  1. In Interactive SQL, press F7 to display a list of tables in the database you are connected to.

    The Interactive SQL Lookup Table Name window.
  2. Select a table and click Show Columns to see the columns for that table.

  3. Press Esc to return to the table list; press Esc again to return to the SQL Statements pane. Press Enter to copy the selected table or column name into the SQL Statements pane at the current cursor position.

  4. Press Esc to leave the list.

    For more information about the tables in the SQL Anywhere sample database, see Tutorial: Connecting to the sample database.


A list of all the tables of the database you are connected to is displayed. You have the option of viewing the columns for each table.