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

# DESCRIBE CREDENTIAL

<a id="sql-desc-credential" />

Outputs the configuration of an existing
[credential](/content/sql/ddl/create-credential#sql-create-credential).

```sql title="DESCRIBE CREDENTIAL Syntax" theme={null}
DESC[RIBE] CREDENTIAL < [<schema name>.]<credential name> | * >
```

Only users with `system_admin` or `system_user_admin`, or users with
`credential_admin` or `credential_read` on the *credential* to describe, may
describe a *credential*.

## Parameters

<AccordionGroup>
  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *credential* to describe
  </Accordion>

  <Accordion title="<credential name>" id="<credential-name>" defaultOpen>
    Name of the existing *credential* for which the configuration will be output; use `*` instead
    of *schema*/*credential* name to output the configuration of all *credentials*
  </Accordion>
</AccordionGroup>

## Response

The response to `DESCRIBE CREDENTIAL` is a four-column result set:

| Output Column         | Description                                                                                                                |
| --------------------- | -------------------------------------------------------------------------------------------------------------------------- |
| `CREDENTIAL_NAME`     | Name of the *credential*                                                                                                   |
| `CREDENTIAL_TYPE`     | Type of the *credential*; see [CREATE CREDENTIAL](/content/sql/ddl/create-credential#sql-create-credential) for values     |
| `CREDENTIAL_IDENTITY` | Username associated with the *credential*                                                                                  |
| `CREDENTIAL_OPTIONS`  | Options associated with the *credential*; see [Options](/content/sql/ddl/create-credential#sql-credential-opts) for values |

## Examples

To show the configuration for a *credential*, `auser_azure_active_dir_creds`:

```sql DESCRIBE CREDENTIAL Example theme={null}
DESCRIBE CREDENTIAL auser_azure_active_dir_creds
```

To show the configuration for all *credentials*:

```sql DESCRIBE CREDENTIAL (All Credentials) Example theme={null}
DESCRIBE CREDENTIAL *
```
