# DROP PROCEDURE statement

The DROP PROCEDURE statement removes the specified Java stored procedure.

A stored procedure is created by a CREATE PROCEDURE statement and is called by a CALL (PROCEDURE) statement.

## Syntax

    DROP PROCEDURE procedureName

Identifies the particular procedure to be dropped, and is valid only if there is exactly one procedure instance with the procedureName in the schema. The identified procedure can have any number of parameters defined for it.

An error will occur in any of the following circumstances:

- If no procedure with the indicated name exists in the named or implied schema (the error is SQLSTATE 42704)
- If there is more than one specific instance of the procedure in the named or implied schema
- If you try to drop a user-defined procedure that is invoked in a trigger

Parent topic: DROP statements
Related reference
DROP DERBY AGGREGATE statement
DROP FUNCTION statement
DROP INDEX statement
DROP ROLE statement
DROP SCHEMA statement
DROP SEQUENCE statement
DROP SYNONYM statement
DROP TABLE statement
DROP TRIGGER statement
DROP TYPE statement
DROP VIEW statement