Syntax
The DROP PROCEDURE statement has the following format:
[EXEC SQL] DROP PROCEDURE [IF EXISTS] proc_name;
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist or exists but is not owned by you. The IF EXISTS clause is typically used prior to issuing the corresponding CREATE statement to ensure that the CREATE statement does not fail due to an existing object of that type.
proc_name
Specifies the name of the procedure to be removed.