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

About the Icon Bar (Query Builder)

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.