ALLBASE/SQL Reference Manual (36216-90216)

404 Chapter10
SQL Statements A - D
DROP PROCEDURE
DROP PROCEDURE
The DROP PROCEDURE statement deletes the specified procedure.
Scope
ISQL or Application Programs
SQL Syntax
DROP PROCEDURE [ Owner .] ProcedureName [PRESERVE]
Parameters
[ Owner .] ProcedureName specifies the name of the procedure that is to be dropped.
PRESERVE specifies that EXECUTE authorities associated with the procedure should
be retained in the system catalog.
Description
• If you do not specify PRESERVE, the EXECUTE authorities associated with the
procedure are removed.
• If a rule attempts to execute a procedure that has been dropped, the rule will fail and
all the effects of the statement that fired the rule are undone.
• The DROP PROCEDURE statement does
not drop rules that invoke the procedure. All
rules invoking the procedure are preserved.
• The DROP PROCEDURE statement will invalidate stored sections that depend on
invoking the procedure from a rule. The loss of the procedure will be reported as an
error when there is an attempt to revalidate these sections.
Authorization
You must be the owner of the procedure or have DBA authority to use the DROP PROCEDURE
statement.
Example
DROP PROCEDURE Process12 PRESERVE