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.
Example
CREATE CREDENTIAL MyCredential WITH IDENTITY = 'JDoe', SECRET = 'sc6l3k$f8-jte6gsi772JFg4';
GO
"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
Related:
ALTER CREDENTIAL
DROP CREDENTIAL
sys.credentials
Password generator