cert-id-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
CERT_ID (Transact-SQL)	CERT_ID (Transact-SQL)	VanMSFT	vanto	07/24/2017	sql	t-sql	reference	ignite-2024	CERT_ID CERT_ID_TSQL	identification numbers [SQL Server], certificates CERT_ID function IDs [SQL Server], certificates certificates [SQL Server], IDs	TSQL	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

CERT_ID (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

This function returns the ID value of a certificate.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

CERT_ID ( 'cert_name' )  

Arguments

' cert_name '

The name of a certificate in the database.

Return types

int

Remarks

The sys.certificates catalog view shows certificate names.

Permissions

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.

Examples

This example returns the ID of a certificate named ABerglundCert3.

SELECT Cert_ID('ABerglundCert3');  
GO  

See also

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