DROP METHOD

DROP METHOD name FROM classname

name

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

FROM classname

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

The DROP METHOD command deletes a method. When you drop a method, 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 method, you must have %DROP_METHOD administrative privilege, as specified by the GRANT command.