Adding tables in the SQL designer

Topic group Related topics

Tables are added to a query in the SQL designer by simply adding them to the table pane. In the table pane you can select some or all fields of one or more tables to be included in the result set. You can also graphically join one table to another. A table may be added more than once.

To add a table, either click the Add Table icon on the toolbar, either press Ctrl+A, choose SQL|Add Table, or choose Add Table from the right-click popup menu. When the Add Table dialog appears, select a table from the list and press Add. You may also to use the Look In list and browse folders to locate additional tables.

When you’re finished adding tables, press Close.

Renaming a table

1. Right-click on the table window and select Edit Table Alias.

2. Type an alias for the table name in the edit box.

Removing a table

3. Right-click on the table window and select Remove Table.

4. A table may also be removed by pressing the Delete button when the table window has focus.