Categories:

UDF (User-Defined Function) & Stored Procedure DDL

DROP PROCEDURE

Removes the specified stored procedure from the current/specified schema.

See also:

ALTER PROCEDURE , SHOW PROCEDURES

Syntax

DROP PROCEDURE [ IF EXISTS ] <procedure_name> ( [ <arg_data_type> , ... ] )

Usage Notes

  • For each argument defined for the procedure, the data type for the argument must be specified. This is required because overloading of procedure names is supported and the data type(s) for the argument(s) are required to identify the procedure.

Examples

DROP PROCEDURE add_accounting_user(varchar);

-------------------------------------------+
             status                        |
-------------------------------------------+
 ADD_ACCOUNTING_USER successfully dropped. |
-------------------------------------------+