sys.certificates (Transact-SQL)

Returns a row for each certificate in the database.

Column name	Data type	Description
name	sysname	Name of the certificate. Is unique within the database.
certificate_id	int	ID of the certificate. Is unique within the database.
principal_id	int	ID of the database principal that owns this certificate.
pvt_key_encryption_type	char(2)	How the private key is encrypted. NA = There is no private key for the certificate MK = Private key is encrypted by the master key PW = Private key is encrypted by a user-defined password SK = Private key is encrypted by the service master key.
pvt_key_encryption_type_desc	nvarchar(60)	Description of how the private key is encrypted. NO_PRIVATE_KEY ENCRYPTED_BY_MASTER_KEY ENCRYPTED_BY_PASSWORD ENCRYPTED_BY_SERVICE_MASTER_KEY
is_active_for_begin_dialog	bit	If 1, this certificate is used to initiate encrypted service dialogs.
issuer_name	nvarchar(442)	Name of certificate issuer.
cert_serial_number	nvarchar(64)	Serial number of certificate.
sid	varbinary(85)	Login SID for this certificate.
string_sid	nvarchar(128)	String representation of the login SID for this certificate
subject	nvarchar(4000)	Subject of this certificate.
expiry_date	datetime	When certificate expires.
start_date	datetime	When certificate becomes valid.
thumbprint	varbinary(32)	SHA-1 hash of the certificate. The SHA-1 hash is globally unique.
attested_by	nvarchar(260)	System use only.

See Also