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.

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