On this page Carat arrow pointing down

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_params_list ) , CASCADE RESTRICT


Parameter Description
func_name The name of one of more functions to drop.
func_params_list An optional list of the function parameters.

See also

Yes No
On this page

Yes No