DROP PROCEDURE
Function
DROP PROCEDURE deletes an existing stored procedure.
Precautions
None.
Syntax
1 | DROP PROCEDURE [ IF EXISTS ] procedure_name ; |
Parameter Description
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 a stored procedure.
1 | DROP PROCEDURE prc_add; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.

