On this page Carat arrow pointing down
CockroachDB v22.2 is no longer supported as of June 5, 2024. For more details, refer to the Release Support Policy.

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


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.


DROP FUNCTION IF EXISTS func_name ( func_args_list ) , CASCADE RESTRICT


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