This wizard allows you to design SQL queries by dragging and dropping tables on the Design tab or typing the complete SQL on the Edit tab.

On the Query Object Editor screen, click Properties > Design. The SQL Designer screen appears.

Entities represent tables from the data source, and attributes are the columns or fields of the selected entity (i.e., table).

The SQL Designer’s left pane lists entities and attributes within the selected entity. The right pane includes the following tabs:

Getting a List of Database Objects

The top line of the screen shows the database connection used to retrieve the list of database objects.

1. Select an object type from Table, View, Procedure, or Synonym.

2. Entities available in the selected connection are listed.

At any given time, the list displays a preset number of entities. If the required entity is not displayed:

• Use the drop-down options to view another set of entities.

• Click Next to load the next list.

• Click Prev to return to the previous list.

When you refresh the screen, the date and time of the last refresh are displayed at the top of the SQL Designer.