Change properties of a credential.
Syntax CREATE 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.
CREATE CREDENTIAL MyCredential WITH IDENTITY = 'JDoe', SECRET = 'sc6l3k$f8-jte6gsi772JFg4';
"Another person's secret is like another person's money: you are not so careful with it as you are of your own" - Edgar Watson Howe