Change properties of a credential.
Syntax
ALTER CREDENTIAL credential WITH IDENTITY = 'identity'
[, SECRET = 'secret']
A credential is a record of the authentication information required to connect to a resource outside SQL Server. Most credentials are a Windows username/password.
When IDENTITY is a Windows username, the SECRET can be the password. Secret is encrypted using the service master key.
Example
ALTER CREDENTIAL MyCredential WITH IDENTITY = 'JDoe';
GO
The above will set the secret (password) for MyCredential to NULL
"In my end is my beginning" ~ Mary Stuart, Queen of Scots
Related commands:
CREATE CREDENTIAL
DROP CREDENTIAL
sys.credentials