DROP ROUTINE

Use the DROP ROUTINE statement to remove a user-defined routine (UDR) from the database.

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-DROP--------------------------------------------------------->
 
>--+-ROUTINE--+------------+--routine--+--------------------------+-+-><
   |          '- owner-- .-'           |    .-,--------------.    | |
   |                                   |    V                |    | |
   |                                   '-(----parameter_type-+--)-' |
   |                                     (1)                        |
   '-SPECIFIC ROUTINE--| Specific Name |----------------------------'

Notes:

See Specific Name

Element	Description	Restrictions	Syntax
owner	Name of UDR owner	Must own the UDR	Owner Name
parameter_type	Data type of a parameter of routine	The data type (or list of data types) must be the same type (and specified in the same order) as in the UDR definition	Identifier; Data Type
routine	Name of the UDR to drop	The UDR must exist (that is, be registered) in the database	Identifier

Usage

Dropping a UDR removes the text and executable versions of the UDR from the database. If you do not know whether a UDR is a user-defined function or a user-defined procedure, this statement instructs the database server to drop the specified user-defined function or user-defined procedure.

To use the DROP ROUTINE statement, you must be the owner of the UDR or have the DBA privilege.

You cannot drop an SPL routine from within the same SPL routine.