FirebirdSQL logo
 TRIGGERFUNCTION 

Who Can Drop a Procedure

The DROP PROCEDURE statement can be executed by:

  • Administrators

  • The owner of the stored procedure

  • Users with the DROP ANY PROCEDURE privilege

DROP PROCEDURE Example

Deleting the GET_EMP_PROJ stored procedure.
DROP PROCEDURE GET_EMP_PROJ;
See also

[fblangref50-ddl-proc-create], [fblangref50-ddl-proc-recreate]