DROP FUNCTION#
Synopsis#
DROP FUNCTION [ IF EXISTS ] routine_name ( [ [ parameter_name ] data_type [, ...] ] )
Description#
Removes a Catalog routines.
The data_types must be included for routines that use parameters to ensure the
routine with the correct name and parameter signature is removed.
The optional IF EXISTS clause causes the error to be suppressed if
the function does not exist.
Examples#
The following example removes the meaning_of_life routine:
DROP FUNCTION meaning_of_life();
If the routine uses a input parameter, the type must be added:
DROP FUNCTION multiply_by_two(bigint);
