602SQL Documentation Index  

Deleting a Routine - DROP PROCEDURE and DROP FUNCTION

statement_DROP_routine ::= DROP [ IF EXISTS ] { PROCEDURE | FUNCTION } [scheme.]name;

This statement deletes a global routine of the specified name.

If the routine of the specified name does not exist in the schema the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

You can also delete a routine from the Control Panel of the 602SQL Client.

WARNING: The routine is physically deleted after the client request that contains this statement is executed and after all prepared statements referring to this routine are revoked (including statements prepared by other clients).

See