Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
Drops an existing credential.
Azure Databricks throws an exception 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 [ FORCE ]
Parameters
IF EXISTSIf specified, Azure Databricks does not throw an exception 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 EXISTShas been specified.The usage of
STORAGEandSERVICE( Databricks Runtime 15.4 and above) is optional.FORCEOptionally force Azure Databricks to drop the credential even if existing objects use it. If
FORCEis not specified, an error is raised when the credential is in use.Important
Forcing the deletion of a storage credential leaves any external locations that depend on it without a valid credential. Those external locations are no longer usable until you assign a new credential.
Examples
> DROP CREDENTIAL street_cred;
-- Drop a storage credential even if external locations depend on it.
> DROP STORAGE CREDENTIAL street_cred FORCE;