<a id="flink-sql-drop-function"></a>

# DROP FUNCTION Statement in Confluent Cloud for Apache Flink

Confluent Cloud for Apache Flink® enables registering custom user-defined functions (UDFs) by
using the [CREATE FUNCTION](create-function.md#flink-sql-create-function) statement. To
remove a registered UDF from the current database, use the DROP FUNCTION
statement.

## Syntax

```sql
DROP FUNCTION [IF EXISTS] [[<catalog_name>].[<database_name>]].<function_name>
```

## Description

Delete a user-defined function (UDF) in Confluent Cloud for Apache Flink.

When you provide the IF EXISTS clause and the function doesn’t exist, no action
is taken.

#### WARNING
Dropping a function that other statements depend on can permanently break
the other statements. If you drop a function and delete its artifact
while a dependent statement is stopped or failed, but not deleted, that
statement can’t resume and fails with an artifact-not-found error,
because its compiled plan still points to the deleted artifact. Before
you drop such a function, follow
[Update a UDF safely](../../how-to-guides/create-udf.md#flink-sql-update-udf).

## Examples

```sql
DROP FUNCTION IF EXISTS `<function_name>`;
```

## Related content

- [CREATE FUNCTION](create-function.md#flink-sql-create-function)
- [SHOW FUNCTIONS](show.md#flink-sql-show-functions)
- [Create a User-Defined Function](../../how-to-guides/create-udf.md#flink-sql-create-udf)
- [Update a UDF safely](../../how-to-guides/create-udf.md#flink-sql-update-udf)

#### NOTE
This website includes content developed at the [Apache Software Foundation](https://www.apache.org/)
under the terms of the [Apache License v2](https://www.apache.org/licenses/LICENSE-2.0.html).
