Selecting tables and views

After you have chosen SQL Select, the Select Tables dialog box displays in front of the Table Layout view of Visual SQL. What tables and views display in the dialog box depends on the DBMS. For some DBMSs, all tables and views display, whether or not you have authorization. Then, if you select a table or view you are not authorized to access, the DBMS issues a message.

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.

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 Visual SQL

The colors used by Visual SQL to display the Table Layout view background and table information are specified in the Enterprise Explorer. You can also set colors for the text and background components in the table header and detail areas.

Adding and removing tables and views

You can add tables and views to your Table Layout view at any time.

**Table 2-3: Adding tables and views in Visual SQL**
To do this	Do this
Add tables or views	Click the Tables button in Visual SQL’s toolbar 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

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.

How Sybase WorkSpace joins tables

If you select more than one table in Visual SQL, Sybase WorkSpace joins columns based on their key relationship.

For information about joins, see “Joining tables”.