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 claues 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.
Description
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.