Changing Credential Password

Requires ALTER ANY CREDENTIAL permissions to be granted.
----------------------------
--changes the password.
ALTER CREDENTIAL WilliamBenson_wbenson007 WITH IDENTITY = 'wbenson007',
    SECRET = '123456789';
GO

--removes the password.
ALTER CREDENTIAL WilliamBenson_wbenson007 WITH IDENTITY = 'wbenson007';
GO