DROP FUNCTION

Private Preview FeatureUser-defined function functionality is currently available as a private preview feature. To enable UDF functionality for your account, please contact Firebolt Support.

Removes a user-defined function from the database. Once dropped, the function can no longer be used in queries.

Syntax

DROP FUNCTION [IF EXISTS] [<schema_name>.]<function_name>

Parameters

Parameter	Description
`IF EXISTS`	Prevents an error if the function does not exist. If specified and the function does not exist, the statement completes successfully without error.
`<schema_name>`	The schema containing the function. Currently, only the `public` schema is supported for user-defined functions.
`<function_name>`	The name of the function to drop. Function names are case-insensitive.

Examples

Drop a function

DROP FUNCTION add_numbers;

Drop a function if it exists

Use IF EXISTS to avoid errors when the function might not exist:

DROP FUNCTION IF EXISTS add_numbers;

Limitations

Built-in functions: You cannot drop built-in Firebolt functions. Attempting to do so results in an error.
CASCADE not supported: The CASCADE option is not supported. If other database objects depend on the function, you must drop them separately.
Schema restriction: Only functions in the public schema can be dropped, as user-defined functions in custom schemas are not currently supported.

CREATE FUNCTION - Create a user-defined function

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Examples

Drop a function

Drop a function if it exists

Limitations

​Syntax

​Parameters

​Examples

​Drop a function

​Drop a function if it exists

​Limitations

​Related

Syntax

Parameters

Examples

Drop a function

Drop a function if it exists

Limitations

Related