DROP CREDENTIAL#

Removes a server-level credential from the server.

Syntax#

DROP CREDENTIAL credential name

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.

Permissions#

Requires the connection-management permission (CreateConnection) on the server.

Examples#

Drop AppCred from the server:

DROP CREDENTIAL AppCred;

See also#