Export (0) Print
Expand All
Expand Minimize

DROP CREDENTIAL (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Removes a credential from the server.

Applies to: SQL Server (SQL Server 2008 through current version).

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft