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

# DROP FUNCTION

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The `DROP FUNCTION` <InternalLink path="sql-statements">statement</InternalLink> removes one or more <InternalLink path="user-defined-functions">user-defined functions</InternalLink> from a database.

The `DROP FUNCTION` statement performs a schema change. For more information about how online schema changes work in CockroachDB, see <InternalLink path="online-schema-changes">Online Schema Changes</InternalLink>.

## Required privileges

To drop a function, a user must have the `DROP` <InternalLink path="security-reference/authorization#managing-privileges">privilege</InternalLink> on the function.

## Synopsis

<img src="https://mintcdn.com/cockroachlabs/Bc-7BE4092mn9J_1/images/sql-diagrams/v23.2/drop_func.svg?fit=max&auto=format&n=Bc-7BE4092mn9J_1&q=85&s=13898dd3b3b22ea6a488f5537e7198dd" alt="drop_func syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="651" height="255" data-path="images/sql-diagrams/v23.2/drop_func.svg" />

## 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

* <InternalLink path="user-defined-functions">User-Defined Functions</InternalLink>
* <InternalLink path="create-function">`CREATE FUNCTION`</InternalLink>
* <InternalLink path="alter-function">`ALTER FUNCTION`</InternalLink>
* <InternalLink path="sql-statements">SQL Statements</InternalLink>
* <InternalLink path="online-schema-changes">Online Schema Changes</InternalLink>
