Add Table dialog box

Add tables to the SQL designer. Each added table appears in the Table View pane at the top of the SQL designer. You can then create relations between the fields of different tables by clicking and dragging between them, and build SQL join and other statements using the controls at the bottom of the dialog box.

The Parameter Name box lists all the parameters used with a specific stored procedure object. Click on a parameter name to display the parameter’s type (in the Parameter Type field) and the parameter value’s data type and value (in the Parameter Value field).

Dialog box options

Look in

The Look In drop-down box lists the last several directories you've had open. You can select one of these, or choose the Folder button to browse to the directory that contains the tables or queries you want to join with SQL statements. Click the folder button to add other directories to the selection list.

Tables

Displays the tables in the directory currently selected in the Look In box. Choose a table to be added to the SQL designer.

How to get there: In the SQL designer, choose SQL|Add Table.