Query Editor window

This window appears when you right-click the Queries node, select Add Query from the shortcut menu, input a name for the new query and then click OK, or right-click a query and click Edit Query on its shortcut menu in the Catalog Browser. It helps you to edit a query. See the window.

The following are details about options in the window:

Query Menu

Column menu

View menu

Help menu

Toolbar

The following are commands on the toolbar:

Criteria panel

Lists all columns added to the query. You can specifically define criteria for the columns in this panel.

SQL

Shows the SQL statement of the query.

Show Paths

Shows information of the pre-join paths among tables in the query, when the pre-join feature is enabled.

OK

Accepts all changes and closes the window.

Cancel

Does not retain any changes and closes the window.

Apply

Accepts all changes in the window.

Help

Displays this help document.

Related topics: