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

# SHOW SECRETS

> Use the `SHOW SECRETS` command to list all secrets in a schema.

## Syntax

```sql theme={null}
SHOW SECRETS [ FROM schema_name ] [ LIKE_expression ];
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                                                                                                                                                                      |
| :------------------ | :------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *schema\_name*      | The schema of the secrets to be listed. If not specified, secrets from all schemas in the current schema [search\_path](https://docs.risingwave.com/operate/view-configure-runtime-parameters#how-to-view-runtime-parameters:~:text=multi%20point%20lookup.-,search_path,-%E2%80%9D%24user%E2%80%9D%2C%20public) will be listed. |
| LIKE\_expression    | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions).                                                                                                                                                     |

## Example

```sql theme={null}
SHOW SECRETS;
```

```bash theme={null}
        Name
---------------------
 public.mysql_pwd
 public.kafka_token
(2 rows)
```

<Note>
  Starting from v2.7.0, the `Name` column in the output includes the schema name as a prefix (e.g., `public.secret_name`). This helps distinguish secrets with the same name in different schemas when querying across multiple schemas in the search path.
</Note>

## Related topics

<CardGroup>
  <Card title="Manage secrets" icon="key" iconType="solid" href="/operate/manage-secrets" horizontal>
    Learn about secret management
  </Card>

  <Card title="CREATE SECRET" icon="circle-plus" iconType="solid" href="/sql/commands/sql-create-secret" horizontal>
    Create a secret
  </Card>

  <Card title="DROP SECRET" icon="trash" iconType="solid" href="/sql/commands/sql-drop-secret" horizontal>
    Drop a secret
  </Card>
</CardGroup>