DROP QUERY

DROP QUERY name FROM classname

name

The name of the query to be deleted. The name is an identifier.

FROM classname

Optional — If specified, the FROM classname clause deletes the query from the given classname. If the FROM clause is not specified, Caché searches all classes of the schema for the query, and deletes it. However, if no query of this name is found, or more than one query of this name is found, an error code is returned. If the deletion of the query results in an empty class, DROP QUERY deletes the class as well.

The DROP QUERY command deletes a query. When you drop a query, Caché revokes it from all users and roles to whom it has been granted and removes it from the database.

In order to drop a query, you must have %DROP_QUERY administrative privilege, as specified by the GRANT command.