Skip to main content
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

ParameterDescription
IF EXISTSPrevents 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.