First Guide to SQL Anywhere Studio
PART 3. Basic SQL
CHAPTER 13. Joining Tables
In Interactive SQL, you can display a list of tables by pressing the f7 key. The tables for the database are prefixed with dba (the owner of the tables).
The cursor keys can be used to scroll through the list of tables. Each table in the list is prefixed with a user name. This prefix is the ID of the user that created the table—the owner of the table.
Positioning the highlight on a particular table and pressing the Columns button displays the list of columns for that table. The escape key takes you back to the table list and pressing it again will take you back to the command window. Pressing enter instead of escape copies the highlighted table or column name into the command window at the current cursor position.
Press escape to leave the list.