DROP PROCEDURE removes the definition of a procedure recorded by CREATE PROCEDURE.
A procedure cannot be dropped if any other objects (procedures, functions, views or pumps) depend on it directly or indirectly - unless the CASCADE option is specified. The default is RESTRICT.
If a procedure has several isomorphs, it is necessary to distinguish between them using a SPECIFIC name - as the DROP PROCEDURE statement does not allow the specification of a signature. For more information on SPECIFIC names see the topic CREATE PROCEDURE in this guide.