DROP SECRET

The DROP SECRET statement deletes an existing secret.

Syntax

DROP SECRET [IF EXISTS] secret_name

• IF EXISTS — the statement does not return an error if the secret does not exist; in this case, it is a no-op.
• secret_name — the name of the secret to delete.

Permissions

Deleting a secret requires the rights REMOVE SCHEMA and ALTER SCHEMA.

Examples

Delete the secret named secret_name:

DROP SECRET secret_name;

Delete the secret named secret_name only if it exists; if it does not exist, the statement is a no-op:

DROP SECRET IF EXISTS secret_name;

See also

• CREATE SECRET
• ALTER SECRET