Updated on 2025-07-22 GMT+08:00

DROP PROCEDURE

Function

DROP PROCEDURE deletes an existing stored procedure.

Precautions

None.

Syntax

1
DROP PROCEDURE [ IF EXISTS  ] procedure_name ;

Parameter Description

Table 1 DROP PROCEDURE parameters

Parameter

Description

Value Range

IF EXISTS

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

-

procedure_name

Specifies the name of the stored procedure to be deleted.

An existing name of a stored procedure.

Examples

Delete the stored procedure:

1
DROP PROCEDURE prc_add;

Helpful Links

CREATE PROCEDURE