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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » 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.

Context and remarks


 Display a list of tables
  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.

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