Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

DROP CREDENTIAL (Transact-SQL)

Removes a credential from the server.

Topic link icon Transact-SQL Syntax Conventions

DROP CREDENTIAL credential_name

credential_name

Is the name of the credential to remove from the server.

To drop the secret associated with a credential without dropping the credential itself, use ALTER CREDENTIAL.

Information about credentials is visible in the sys.credentials catalog view.

Caution note Caution

Proxies are associated with a credential. Deleting a credential that is used by a proxy leaves the associated proxy in an unusable state. When dropping a credential used by a proxy, delete the proxy (by using sp_delete_proxy (Transact-SQL) and recreate the associated proxy by using sp_add_proxy (Transact-SQL).

Requires ALTER ANY CREDENTIAL permission. If dropping a system credential, requires CONTROL SERVER permission.

The following example removes the credential called Saddles.

DROP CREDENTIAL Saddles;
GO

Community Additions

ADD
Show:
© 2015 Microsoft