sys.credentials (Transact-SQL)

credential_id

int

ID of the credential. Is unique in the server.

name

sysname

Name of the credential. Is unique in the server.

credential_identity

nvarchar(4000)

Name of the identity to use. This will generally be a Windows user. It does not have to be unique.

create_date

datetime

Time at which the credential was created.

modify_date

datetime

Time at which the credential was last modified.

target_type

nvarchar(100)

Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Understanding Extensible Key Management (EKM).

target_id

int

ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Understanding Extensible Key Management (EKM).