| title | sys.certificates (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | e5046102-a65c-401e-b80d-05636884dec9 | ||||
| caps.latest.revision | 39 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-all_md]
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. |
| pvt_key_last_backup_date | datetime | The date and time the certificate’s private key was last exported. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Encryption Hierarchy
CREATE CERTIFICATE (Transact-SQL)