---
sidebar_position: 1
title: DROP SECRET
description: Delete a secret from MotherDuck or local storage.
---
# DROP SECRET

The DuckDB `DROP SECRET` statement (see DuckDB [DROP SECRET documentation](https://duckdb.org/docs/sql/statements/create_secret#syntax-for-drop-secret)) works in MotherDuck to delete the secret previously created with `CREATE SECRET` statement.

# Syntax

```sql
DROP SECRET <secret_name>;
```

When there are multiple secrets with the same name stored in different secret storages (e.g. in memory vs. in MotherDuck), either the persistent type or the secret storage type needs to be specified to remove ambiguity when dropping the secret.

# Example Usage
Disambiguate by specifying the storage type when dropping a secret:

```sql
DROP SECRET __default_s3 FROM motherduck;
```

Disambiguate by specifying the persistence type when dropping a secret:

```sql
DROP PERSISTENT SECRET __default_s3;
```