DROP CREDENTIAL#
Removes a server-level credential from the server.
Syntax#
Arguments#
credential_name
The name of the credential to remove.
Remarks#
IF EXISTS is not supported. Dropping a credential that does not exist raises an error.
A credential is cluster-wide, so dropping it removes it from every node of the cluster.
When auditing is enabled, every execution of this statement is recorded in the audit trail — including an attempt refused for a missing permission or naming a credential that does not exist.
Permissions#
Requires the connection-management permission (CreateConnection) on the server.
Examples#
Drop AppCred from the server:
DROP CREDENTIAL AppCred;