A script-enabled browser is required for this page to function properly.

Query window

When you open a query, Query Builder displays it in the Query window, which includes:

Depending on your preferences, the panels may be split vertically or horizontally.

Each table is displayed in a box containing the name of the table and the names of columns in that table. There are a number of icons that help identify the current database object. The icons indicate whether descriptive comments are attached, the type of data source, the column's datatype, and whether indexes have been defined for tables in the query.

Lines are drawn to indicate the relationships between columns. Relationships are set up between tables to identify how a column in one table relates to a column in another table.

A check mark to the left of the column name indicates the column has been included in the query. This means that Query Builder will search for data corresponding to the column name when you run the query. No check mark indicates that column's data will not be included.

The Conditions panel

The Conditions panel is the left-hand section of the Query window that contains the Condition field, where you enter expressions and conditions. Query Builder conditions automatically generate WHERE or HAVING clauses, as appropriate.  You can size the Conditions panel as desired.

The table and column names indicate which columns will be filtered in the condition. You may omit the table name if the column name is unique.

Note: When you activate the Condition field, the cursor will have a (+) sign, indicating that any item you click on will be added to your condition. To deactivate this, you can click the Cancel button in the Icon bar.

The Data Source panel

The Data source panel is the right-hand section of the Query window where items, such as tables and relationships, display.

The Icon bar

The Icon bar displays at the top of the Query window. click each icon to view a description.

the Icon bar

the Icon bar

Save icon

Saves your query to the specified file.

Cut icon

Cuts the selected text and places it on your operating system's clipboard.

Copy icon

Copies the selected text onto your operating system's clipboard while the original text remains intact.

Paste icon

Pastes the current clipboard items into the active location. If there is nothing on the clipboard, nothing will be pasted. You can paste any text that you have cut or copied.

Clear icon

Removes the selected item (that is, text, table). Unlike the Cut command, Clear does not place the removed item(s) on your operating system's clipboard.

Select All icon

Selects every item in the active window. For example, if the Conditions panel is active, all conditions in the panel will be selected.

Select Data Tables icon

Displays the Select Data Tables dialog box.

Select Related Tables icon

Displays the Select Related Tables dialog box. This icon is available only when the table you have selected has a related table in the connected database.

Rename Table icon

Displays the Rename Table dialog box. This icon is available only when there is at least one table in the Query Builder workspace.

Get Info icon

Displays the Info dialog box and information on the selected database object. This icon is available only if a data source object is active.

Set Table Relationship icon

Displays the Set Relationship dialog box. This icon is available only when there is more than one table in the Datsource panel to relate.

Show SQL icon

Displays the Show SQL dialog box and the SQL for the active query.

Column Sequence icon

Displays the Display dialog box.

Define Column icon

Displays the Define Column dialog box.

Sort icon

Displays the Sort dialog box.

And icon

Inserts the AND operator into your condition. This icon is available only when the Condition field is active. You can also type AND directly into the Condition field.

Or icon

Inserts the OR operator into your condition. This icon is available only when the Condition field is active. You can also type OR directly into the Condition field.

Not icon

Inserts the NOT operator into your condition to negate your condition. This icon is available only when the Condition field is active. You can also type NOT directly into the Condition field.

Ungroup Conditions icon

Ungroups conditions that are combined with logical operators, such as AND, OR, NOT. This icon is available only when you have selected a logical operator in the Conditions panel.

Accept icon

Validates and accepts the active condition. This icon is available only when the Condition field is active. You can also press the Enter or Return key when the Condition field is active to accept and validate your condition.

Cancel icon

Cancels the current condition. This icon is available only when the Condition field is active.

Paste Column icon

Displays the Paste Column dialog box. This icon is available only when the Condition field is active.

Paste Function icon

Displays the Paste Function dialog box. This icon is available only when the Condition field is active.