On this page 
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_params_list |
An optional list of the function parameters. |
