You can use the DROP PROCEDURE statement to delete a procedure form the database.

DROP PROCEDURE [ IF EXISTS ] name [ (parameters) ]
    [ CASCADE | RESTRICT ];

name is the name of the procedure to be dropped.

Note In a PolarDB for PostgreSQL(Compatible with Oracle), you need to specify the parameter list under certain circumstances such as if this is an overloaded procedure. Oracle requires that the parameter list always be omitted.

Usage of IF EXISTS, CASCADE, or RESTRICT is not compatible with Oracle databases. For more information about these options, see the DROP PROCEDURE statement in the Database Compatibility for Oracle Developers Reference Guide.

The following example describes how to drop the previously created procedure:

DROP PROCEDURE simple_procedure;