All Products
Search
Document Center

MaxCompute:DROP FUNCTION

Last Updated:Mar 26, 2026

Drops an existing user-defined function (UDF) from a MaxCompute project.

Syntax

drop function <function_name>;

Parameters

ParameterRequiredDescription
function_nameYesThe name of the UDF to drop.

Examples

Drop the my_lower function:

drop function my_lower;

What's next

  • CREATE FUNCTION: Creates a UDF in a MaxCompute project.

  • CREATE SQL FUNCTION: Creates a permanent SQL function stored in the metadata system, making it available to all query statements.

  • FUNCTION: Creates a temporary SQL function without storing it in the metadata system.

  • DESC FUNCTION: Views the details of a specified UDF, including its name, owner, creation time, class name, and resource list.

  • LIST FUNCTIONS: Views all UDFs in a MaxCompute project.

  • SELECT FUNCTION: Calls an SQL function.