DROP PROCEDURE¶
Function¶
DROP PROCEDURE deletes an existing stored procedure.
Precautions¶
None.
Syntax¶
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:
DROP PROCEDURE prc_add;