Skip to main content
Outputs the DDL statement required to reconstruct the given credential.
SHOW CREDENTIAL Syntax
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.
The response to SHOW CREDENTIAL is a single-column result set with the DDL statement as the value in the DDL column.

​
Parameters

<schema name>

Name of the schema containing the credential to show

<credential name>

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

​
Examples

To output the DDL for a credential, auser_azure_active_dir_creds:
SHOW CREDENTIAL Example
To output the DDL for all credentials:
SHOW CREDENTIAL (All Credentials) Example