DROP PROCEDURE

This statement removes a stored procedure from the database.

See also CREATE PROCEDURE.

Syntax

DROP PROCEDURE [IF EXISTS] folder_name.proc_name

Parameters

IF EXISTS: If this clause is specified, the DROP PROCEDURE statement will not fail if the procedure does not exist.

Examples

Create a stored procedure:

CREATE OR REPLACE PROCEDURE mkw_doku.proc1(vari INTEGER)
RETURNS STRING
AS
    BEGIN
    RETURN vari;
    END;

CALL mkw_doku.proc1(1);

+-------+
| PROC1 |
+-------+
| 1     |
+-------+

Drop the procedure:

DROP PROCEDURE IF EXISTS mkw_doku.proc1(INTEGER);

CALL mkw_doku.proc1(1);

InvalidReference: Procedure 'mkw_doku.proc1' does not exist!
 at mkw_doku.test_abfragen (1:1)