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

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>;
};

You can use external connections to specify and interact with resources that are external from CockroachDB. When creating an external connection, you define a name for an external connection while passing the provider URI and query parameters. The `DROP EXTERNAL CONNECTION` statement allows you to delete external connections.

You can also use the following SQL statements to work with external connections:

* <InternalLink path="create-external-connection">`CREATE EXTERNAL CONNECTION`</InternalLink>
* <InternalLink path="show-create-external-connection">`SHOW CREATE EXTERNAL CONNECTION`</InternalLink>

## Required privileges

Users must have the <InternalLink path="security-reference/authorization#supported-privileges">`DROP` privilege</InternalLink> or be a member of the <InternalLink path="security-reference/authorization#admin-role">`admin` role</InternalLink> to drop an external connection.

For example:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
GRANT DROP ON EXTERNAL CONNECTION backup_bucket TO user;
```

## Synopsis

<img src="https://mintcdn.com/cockroachlabs/ulDoMGhKYg9RNabd/images/sql-diagrams/v23.1/drop_external_connection.svg?fit=max&auto=format&n=ulDoMGhKYg9RNabd&q=85&s=015f87107b717089bdeafd5497c41fbe" alt="drop_external_connection syntax diagram" style={{maxWidth: "100%", overflowX: "auto"}} width="511" height="37" data-path="images/sql-diagrams/v23.1/drop_external_connection.svg" />

### Parameters

| Parameter         | Description                                                          |
| ----------------- | -------------------------------------------------------------------- |
| `connection_name` | The name of the external connection to pass in operation statements. |

## Examples

### Drop an external connection

To delete an external connection named `backup_storage`, run the following:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DROP EXTERNAL CONNECTION backup_storage;
```

## See also

* <InternalLink path="use-cloud-storage">Use Cloud Storage</InternalLink>
* <InternalLink path="changefeed-sinks">Changefeed Sinks</InternalLink>