DROP FUNCTION

On this page Carat arrow pointing down
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.

The DROP FUNCTION statement removes one or more user-defined functions from a database.

Note:

The DROP FUNCTION statement performs a schema change. For more information about how online schema changes work in CockroachDB, see Online Schema Changes.

Required privileges

To drop a function, a user must have the DROP privilege on the function.

Synopsis

DROP FUNCTION IF EXISTS func_name ( func_params_list ) , CASCADE RESTRICT

Parameters

Parameter Description
func_name The name of one of more functions to drop.
func_args_list A list of the function arguments.

See also


Yes No
On this page

Yes No