Deletes an existing stored procedure from a database. Available in DSQL, and
DROP PROCEDURE name
Name of an existing stored procedure
DROP PROCEDURE removes an existing stored procedure definition from a database.
Procedures used by other procedures, triggers, or views cannot be dropped. Procedures currently in use cannot be dropped.
A procedure can be dropped by its creator, the
SYSDBA user, or any user with operating system root privileges.
Example: The following
isql statement deletes a procedure:
DROP PROCEDURE GET_EMP_PROJ;