Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Removes a credential from the server.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DROP CREDENTIAL credential_name
Arguments
- credential_name
Is 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.
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
See Also
Reference
CREATE CREDENTIAL (Transact-SQL)
ALTER CREDENTIAL (Transact-SQL)
sys.credentials (Transact-SQL)