Selecting a table

When you choose Quick Select, the Quick Select dialog box displays. The Tables box lists tables and views in the current database.

Displaying table comments To display a comment about a table, position the pointer on the table and click the right mouse button or select the table.

Which tables and views display?

The DBMS determines what tables and views display. For some DBMSs, all tables and views display, whether or not you have authorization. If you select a table or view you are not authorized to access, the DBMS issues a message.

For ODBC databases, the tables and views that display depend on the driver for the data source. SQL Anywhere does not restrict the display, so all tables and views display, whether or not you have authorization.

Tables with key relationships

When you select a table, the table's column names display in the Columns box, and any tables having a key relationship with the selected table display in the Tables box. These tables are indented. You can select any of these related tables if you want to include columns from them in the DataWindow object.

The sample Quick Select dialog box shows the Tables box at left with employee table selected. Indented below the employee table are the related department and sales _ order tables. Under the box is a comment line, "A list of all employees within the company." A Column box on the right lists the columns for the employee table. At the bottom is a scrollable area for entering text with labels that read column, sort, criteria, or.

How columns from additional tables display

The column names of selected tables display in the Columns box. If you select more than one table, the column names are identified as:

tablename.columnname

For example, department.dept_name and employee.emp_id display when the Employee table and the Department table are selected.

To return to the original table list Click the table you first selected at the top of the table list.