Selecting tables and views

After you have chosen SQL Select, the Select Tables dialog box displays in front of the Table Layout view of the Select painter. What tables and views display in the dialog box depends on the DBMS. SQL Anywhere does not restrict the display, so all tables and views display, whether or not you have authorization.

To select the tables and views:

Do one of the following:
- Click the name of each table or view you want to open
  
  Each table you select is highlighted. (To deselect a table, click it again.) Click the Open button to close the Select Tables dialog box.
- Double-click the name of each table or view you want to open
  
  Each object opens immediately behind the Select Tables dialog box. Click the Cancel button to close the Select Tables dialog box.

Representations of the selected tables and views display. You can move or size each table to fit the space as needed.

Below the Table Layout view, several tabbed views also display by default. You will use the views (for example, Compute, Having, Group) to specify the SQL Select statement in more detail.You can turn the views on and off from the View menu on the menu bar.

Figure 17-16: Table and column selection using SQL Select

The sample shows the Table Layout view of the Select painter. The view displays the columns of department and employee tables, listing the columns in each. The name, label, and datatype for each column is shown, and the tables are joined at the dept _ i d column. The Syntax view at the bottom of the sample screen displays the sequel Select statement for the table selections.

Specifying what is displayed

You can display the label and datatype of each column in the tables. (The label information comes from the extended attribute system tables.) If you need more space, you can choose to hide this information.

To hide or display comments, datatypes, and labels:

Position the pointer on any unused area of the Table Layout view and select Show from the pop-up menu.

A cascading menu displays.
Select or clear Datatypes, Labels, or Comments as needed.

Colors in the Select painter

In the Database painter, you select the colors used by the Select painter to display the Table Layout view background and table information. You can also set colors for the text and background components in the table header and detail areas.

For more information about specifying colors in the Database painter, see “Modifying database preferences”.

Adding and removing tables and views

You can add tables and views to your Table Layout view at any time. You can also remove individual tables and views from the Table Layout view, or clear them all at once and begin selecting a new set of tables.

**Table 17-4: Adding tables and views in the Select painter**
To do this	Do this
Add tables or views	Click the Tables button in the PainterBar and select tables or views to add
Remove a table or view	Display its pop-up menu and select Close
Remove all tables and views	Select Design>Undo All from the menu bar

How PocketBuilder joins tables

If you select more than one table in the Select painter, PocketBuilder joins columns based on their key relationship.

For information about joins, see “Joining tables”.