THIS TOPIC APPLIES TO:SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
Returns a row for each certificate in the database.
Name of the certificate. Is unique within the database.
ID of the certificate. Is unique within the database.
ID of the database principal that owns this certificate.
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.
Description of how the private key is encrypted.
If 1, this certificate is used to initiate encrypted service dialogs.
Name of certificate issuer.
Serial number of certificate.
Login SID for this certificate.
String representation of the login SID for this certificate
Subject of this certificate.
When certificate expires.
When certificate becomes valid.
SHA-1 hash of the certificate. The SHA-1 hash is globally unique.
System use only.
The date and time the certificate’s private key was last exported.
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.