Drop Procedure Syntax
From InterBase
Go Up to Altering and Dropping Stored Procedures
The syntax for dropping a procedure is:
DROP PROCEDURE name;
The procedure <name> must be the name of an existing procedure. The following statement deletes the ACCOUNTS_BY_CLASS
procedure:
DROP PROCEDURE ACCOUNTS_BY_CLASS;