DROP PROCEDURE
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes an existing stored procedure from a database. Available in DSQL, and isql
.
DROP PROCEDURE name
Argument | Description |
---|---|
<name> |
Name of an existing stored procedure |
Description: 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.
- Tip: In
isql
, SHOW PROCEDURE displays a list of procedures’ dependencies, the procedures, triggers, exceptions, and tables that use the procedures.
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;