Drop a user-defined routine

You can use the DROP FUNCTION, DROP PROCEDURE, and DROP ROUTINE statements to drop a previously defined UDR. These statements remove the text and executable versions of the routine from the database.

You cannot drop a UDR that is in use by some database function, such as the definition of an opaque data type, a cast, a user-defined aggregate, an operator class, or an access method.

For information about these SQL statements, refer to their description in the HCL OneDB™ Guide to SQL: Syntax.