DROP DATABASE SCOPED CREDENTIAL#
Removes a database scoped credential from the current virtual database.
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.
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 current virtual database:
DROP DATABASE SCOPED CREDENTIAL AppCred;