# DROP LINK

The `DROP LINK` command removes a connection link on S3, Azure, GCS, HDFS, or Kafka for a permitted user.

## Syntax

```
DROP LINK [db_name.]connection_name

```

## Remarks

* `db_name` is the name of the SingleStore database. It is an optional parameter. If not specified, the connection link is dropped from the current (context) database.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.
* To drop a connection link, you need the [`DROP LINK`](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) permission. Contact your administrator to grant this permission.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

```sql
SHOW LINKS ON Orderdb;

```

```output
       
+-------------------------+--------+-----------------------------+
| Link                    | Type   | Description                 |
+-------------------------+--------+-----------------------------+
| product_S3              | S3     | Product list                |
| brand_S3                | S3     | Brand list                  |
+-------------------------+--------+-----------------------------+

```

```sql
DROP LINK Orderdb.brand_S3;

SHOW LINKS ON Orderdb;

```

```output

+-------------------------+--------+-----------------------------+
| Link                    | Type   | Description                 |
+-------------------------+--------+-----------------------------+
| product_S3              | S3     | Product list                |
+-------------------------+--------+-----------------------------+

```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/security-management-commands/drop-link/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/drop-link/)

(An index of the documentation is available at /llms.txt)