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 on these SQL statements, refer to their description in the IBM Informix: Guide to SQL Syntax.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]