On this page
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
Parameters
Parameter | Description |
---|---|
func_name |
The name of one of more functions to drop. |
func_args_list |
A list of the function arguments. |