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 |
