DROP PROCEDURE

Function

DROP PROCEDURE deletes an existing stored procedure.

Precautions

None.

Syntax

1

DROP PROCEDURE [ IF EXISTS  ] procedure_name ;

Parameter Description

• 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.

  Value range: An existing stored procedure name.

Examples

Delete the stored procedure:

1

DROP PROCEDURE prc_add;

Helpful Links

CREATE PROCEDURE