DROP PROCEDURE
From InterBase
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
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;