Skip to main content

ALTER FUNCTION

Introduced or updated: v1.2.116

Alters a user-defined function.

Syntax

ALTER FUNCTION [ IF NOT EXISTS ] <function_name> 
AS (<input_param_names>) -> <lambda_expression>
[ DESC='<description>' ]

Examples

-- Create a UDF
CREATE FUNCTION a_plus_3 AS (a) -> a+3+3;

-- Modify the lambda expression of the UDF
ALTER FUNCTION a_plus_3 AS (a) -> a+3;
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today