DROP FUNCTION removes the definition of a user -defined function from the database.
For more detail, see the topic CREATE FUNCTION in this guide.
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 topicCREATE 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.
-- drop a function by name DROP FUNCTION math.factorial -- drop a function by its specific name DROP SPECIFIC FUNCTION binomial