sys.dm_external_provider_certificate_info (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Note
This view is introduced in SQL Server 2022 CU1.
Returns information about the Azure cloud certificates used in SQL Server to set up and maintain a Microsoft Entra administrator required to support Microsoft Entra authentication. For more information, see Set up Microsoft Entra authentication for SQL Server.
| Column name | Data type | Description |
|---|---|---|
| Subject | nvarchar(4000) | The subject name of the certificate. |
| thumbprint | nvarchar(4000) | Certificate thumbprint. |
| expire_date | datetime2 | Certificate expiration date and time. |
| is_readable | bit | Indicates whether the certificate is readable for both public and private key. Values are: 1 - Yes 0 - No |
| is_missing | bit | Indicates whether the certificate is present in the certificate store. Values are: 1 - Yes 0 - No |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
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.