DROP CREDENTIAL

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

Drops an existing credential. An exception is thrown if the location does not exist in the metastore. To drop a credential you must have the MANAGE privilege on the credential or be its owner.

Syntax

DROP [ STORAGE | SERVICE ] CREDENTIAL [ IF EXISTS ] credential_name

Parameters

• IF EXISTS

  If specified, no exception is thrown when the credential does not exist.

• [ STORAGE | SERVICE ] credential_name

  The name of an existing credential in the metastore. If the name does not exist, an exception is thrown unless IF EXISTS has been specified.

  The usage of STORAGE and SERVICE ( Databricks Runtime 15.4 and above) is optional.

Examples

> DROP CREDENTIAL street_cred;

Related articles

• ALTER CREDENTIAL
• DESCRIBE CREDENTIAL
• SHOW CREDENTIALS