Updated on 2024-06-03 GMT+08:00

DROP PROCEDURE

Function

Deletes a stored procedure.

Syntax

DROP PROCEDURE [ IF EXISTS ] procedure_name;

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the specified stored procedure does not exist.

  • procedure_name

    Specifies the name of the stored procedure to be deleted.

    Value range: an existing stored procedure name

Examples

For details, see 8.12.8.35-Examples in section "CREATE PROCEDURE."

Helpful Links

ALTER PROCEDURE and CREATE PROCEDURE