नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
SQL Server
Azure SQL Managed Instance
Removes a credential from the server.
Transact-SQL syntax conventions
Syntax
DROP CREDENTIAL credential_name
Arguments
credential_name
The name of the credential to remove from the server.
Remarks
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.
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) and recreate the associated proxy (by using sp_add_proxy).
Permissions
Requires ALTER ANY CREDENTIAL permission. If dropping a system credential, requires CONTROL SERVER permission.
Examples
The following example removes the credential called Saddles.
DROP CREDENTIAL Saddles;
GO