> ## 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.

# SHOW CREDENTIAL

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

Outputs the DDL statement required to reconstruct the given
[credential](/content/sql/ddl/create-credential#sql-create-credential).

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

The `secret` value will be masked and would need to be replaced with the
actual `secret` value if attempting to reconstruct the *credential*.  Only
users with `system_admin` or `system_user_admin`, or users with
`credential_admin` or `credential_read` on the *credential* to show, may
show a *credential*.

<Info>
  The response to `SHOW CREDENTIAL` is a single-column result set
  with the DDL statement as the value in the `DDL` column.
</Info>

## Parameters

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

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

## Examples

To output the DDL for a *credential*, `auser_azure_active_dir_creds`:

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

To output the DDL for all *credentials*:

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