CERT_ID (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

This function returns the ID value of a certificate.

Transact-SQL syntax conventions

CERT_ID ( 'cert_name' )  

' cert_name '

The name of a certificate in the database.

int

The sys.certificates catalog view shows certificate names.

Requires appropriate permission(s) on the certificate, and requires that the caller has not been denied VIEW DEFINITION permission on the certificate. See CREATE CERTIFICATE (Transact-SQL) for more information about certificate permissions.

This example returns the ID of a certificate named ABerglundCert3.

SELECT Cert_ID('ABerglundCert3');  
GO  

sys.certificates (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
Encryption Hierarchy