DROP PROCEDURE deletes a procedure.
Procedures and their use in SESAM/SQL are described in detail in chapter "Routines".
You can ascertain which routines are defined and which routines use each other in the views for routines of the INFORMATION_SCHEMA (see chapter "Information schemas").
When the procedure is deleted, the EXECUTE privilege for this procedure is revoked from the current authorization identifier. EXECUTE privileges which have been passed on are also revoked.
The current authorization identifier must own the schema to which the procedure belongs.
DROP PROCEDURE procedure { CASCADE | RESTRICT }
procedure ::= routine
procedure
Name of the procedure. You can qualify the procedure name with a database and schema name.
CASCADE
The procedure procedure and each routine which procedure calls directly or indirectly are deleted. Views which procedure uses indirectly via a UDF are also deleted.
RESTRICT
The procedure procedure can be deleted only if procedure is used by no other routine.
See also
CREATE PROCEDURE, CREATE FUNCTION, CALL