Switch to: V9V8V7V6V5

DROP PROCEDURE/FUNCTION

Drops the specified routine from the database.

Syntax

drop_procedure_stmt
    :    DROP PROCEDURE [IF EXISTS] proc_name

drop_function_stmt
    :    DROP FUNCTION [IF EXISTS] func_name

Arguments

[IF EXISTS]

Do not raise error in case there is no routine with the specified name.

proc_name

The name of routine to be deleted.