Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
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.
|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||Date and time when certificate expires.|
|start_date||datetime||Date and time 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.|
|pvt_key_last_backup_date||datetime||The date and time the certificate's private key was last exported.|
|key_length||int||The certificate's key length.
Applies to: SQL Server 2016 (13.x) and later versions.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.