> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/ddl/drop-secret.md).

# DROP SECRET

## Synopsis <a href="#synopsis" id="synopsis"></a>

```sql
DROP SECRET secret_name;
```

## Description

Drops an existing secret. You cannot drop a secret if it is referenced by an active query.

{% hint style="warning" %}
**Important** `DROP SECRET` cannot be undone. Use it with care!
{% endhint %}

### Arguments

#### secret\_name

The name of the secret to drop. If the name is case-sensitive, you must wrap it in double quotes; otherwise, the system uses the lower case name.

## Example

#### Drop a secret

```sh
db1.public/my_store# DROP SECRET mysecret;
+------------+------------+------------+------------------------------------------+
|  Type      |  Name      |  Command   |  Summary                                 |
+============+============+============+==========================================+
| secret     | mysecret   | DROP       | secret "mysecret" has been marked for    |
|            |            |            | deletion                                 |
+------------+------------+------------+------------------------------------------+
db1.public/my_store# LIST SECRETS;
+------------+------------+--------------+----------------+------------+------------+-------------+-------------+
|  Name      |  Type      |  Description |  Access Region |  Status    |  Owner     |  Created At |  Updated At |
+============+============+==============+================+============+============+=============+=============+
+------------+------------+--------------+----------------+------------+------------+-------------+-------------+
```