DROP FUNCTION¶

DROP FUNCTION can be used to remove a user defined function.

Permissions¶

The role must have the DDL permission at the database level.

DROP FUNCTION [ IF EXISTS ] function_name()

function_name ::= identifier

Parameter	Description
`IF EXISTS`	Drop the function if it exists. Does not error if the function does not exist.
`function_name()`	The name of the function to drop.

Dropping a function:

DROP FUNCTION my_distance();