DROP PROCEDURE

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > DROP statements >

DROP PROCEDURE

Previous pageReturn to chapter overviewNext page

DROP PROCEDURE removes the definition of a procedure recorded by CREATE PROCEDURE.

Syntax

dropprocedure

Notes

A procedure cannot be dropped if any other objects (procedures, functions, views or pumps) depend on it directly or indirectly - unless the CASCADE option is specified. The default is RESTRICT.

If a procedure has several isomorphs, it is necessary to distinguish between them using a SPECIFIC name - as the DROP PROCEDURE statement does not allow the specification of a signature. For more information on SPECIFIC names see the topic CREATE PROCEDURE in this guide.