DROP FUNCTION

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > DROP statements >

DROP FUNCTION

Previous pageReturn to chapter overviewNext page

DROP FUNCTION removes the definition of a user -efined function from the database.

For more detail, see the topic CREATE FUNCTION in this guide.

Syntax

dropfunction

Notes

If SPECIFIC is specified, the system will look for the function by its specific name. This is necessary when several isomorphs with the same function name but different signatures exist. For more information on SPECIFIC names, see the topic CREATE FUNCTION in this guide.

If the CASCADE option is chosen, all dependent objects (which could be functions or procudures which directly or indirectly call the function, or views or pumps which reference the function directly or indirectly) are also removed.

If the RESTRICT option is chosen, an exception will be raised and the function will not be dropped if any other objects (functions, procedures, views or pumps) depend on it.

If neither CASCADE nor RESTRICT is explicitly chosen, the default is RESTRICT.

Examples

-- drop a function by name

DROP FUNCTION math.factorial

-- drop a function by its specific name

DROP SPECIFIC FUNCTION binomial