Delete Query

If a query is no longer needed, you can delete it using the Delete Query command. 

delete query NAME [user USER_NAME];
  • NAME is the name of the query to be deleted. If you are a business administrator with person access, you can include the User clause to indicate another user’s workspace object.

This command searches the local list of existing queries. If the name is found, that query is deleted. If the name is not found, an error message results.

For example, assume you have a query named “Overdue Invoices” that you no longer need. To delete this query from your area, you would enter the following MQL command: 

delete query “Overdue Invoices”;

After this command is processed, the query is deleted and you receive the MQL prompt for the next command.

When a query is deleted, there is no effect on the business objects or on queries performed by other users. Queries are local only to the user’s context and are not visible to other users.