Editing a query

To edit a query right-click on the query name in Database Manager and then select Format. The "Format Query" dialog is displayed. Alternatively, if you are already in a table, query table or relation, you can select Query from the Format menu.

You can edit a query by going to the Query page in "Format Query". If you change the name of the query, the edited query will be saved under the new name and the original retained. If you then wish to delete the original, you can do so in Database Manager (see Deleting a database object).

To edit a query without changing its name, that is to say, the edited query is saved under its existing name, use the drop-down lists in the Select Query Components group box to select the new query components (select None if you want to exchange a selected component for no other component).

Note that in editing a query you can go to the other pages in the "Format query" dialog and edit or create new query components as required. See Editing query components.

When you have finished editing the query click on OK.