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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Joins: Retrieving Data from Several Tables » Introduction

Introduction Next Page

Displaying a list of tables

In Interactive SQL, you can display a list of tables in the database you are connected to by pressing the F7 key.

The Interactive SQL Lookup Table Name dialog.

Select a table and click Show Columns to see the columns for that table. The Escape key takes you back to the table list, and pressing it again will take you back to the SQL Statements pane. Pressing Enter instead of Escape copies the selected table or column name into the SQL Statements pane at the current cursor position.

Press Escape to leave the list.

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