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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Joins: Retrieving data from several tables

 

Displaying a list of tables

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.

Select a table and click Show Columns to see the columns for that table. 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.

Press Esc to leave the list.

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