drop procedure

Drop a stored procedure

Syntax

drop_proc:
          DROP PROCEDURE proc_name

Description

This statement can be used to drop (delete) a stored procedure. Note that this statement is not transactional—the function is deleted upon execution of the DROP PROCEDURE statement.

Example

create procedure getacct(mid char)
begin
 	select * from acctmgr where mgrid = mid
end;
...
call getacct("JOE");
...
drop procedure getacct;