# 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.

## Syntax¶

drop_function_statement ::=
DROP FUNCTION [ IF EXISTS ] function_name();
;

function_name ::= identifier


## Parameters¶

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.

## Examples¶

### Dropping a function¶

DROP FUNCTION my_distance();


### Dropping a function (always succeeds)¶

farm=> DROP FUNCTION my_distance();
executed

farm=> DROP FUNCTION my_distance();
Function 'my_distance' not found

-- This will succeed, even though the function does not exist
farm=> DROP FUNCTION IF EXISTS my_distance();
executed