> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP FUNCTION

The `DROP FUNCTION` [statement](https://docs.cockroachlabs.com/docs/v24.2/sql-statements) removes one or more [user-defined functions](https://docs.cockroachlabs.com/docs/v24.2/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](https://docs.cockroachlabs.com/docs/v24.2/online-schema-changes).

## Required privileges

To drop a function, a user must have the `DROP` [privilege](https://docs.cockroachlabs.com/docs/v24.2/security-reference/authorization#managing-privileges) on the function.

## Synopsis

![drop\_func syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/drop_func.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=9ca5c4da39d9e936e51b86af41e55951)

## Parameters

| 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

* [User-Defined Functions](https://docs.cockroachlabs.com/docs/v24.2/user-defined-functions)
* [`CREATE FUNCTION`](https://docs.cockroachlabs.com/docs/v24.2/create-function)
* [`ALTER FUNCTION`](https://docs.cockroachlabs.com/docs/v24.2/alter-function)
* [SQL Statements](https://docs.cockroachlabs.com/docs/v24.2/sql-statements)
* [Online Schema Changes](https://docs.cockroachlabs.com/docs/v24.2/online-schema-changes)