> ## 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](/docs/stable/sql-statements.md) removes one or more [user-defined functions](/docs/stable/user-defined-functions.md) 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](/docs/stable/online-schema-changes.md).

## Required privileges

To drop a function, the user must be the owner of 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](/docs/stable/user-defined-functions.md)
* [`CREATE FUNCTION`](/docs/stable/create-function)
* [`ALTER FUNCTION`](/docs/stable/alter-function)
* [SQL Statements](/docs/stable/sql-statements.md)
* [Online Schema Changes](/docs/stable/online-schema-changes.md)