cert-id-transact-sql.md

title	CERT_ID (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/24/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	CERT_ID CERT_ID_TSQL
dev_langs	TSQL
helpviewer_keywords	identification numbers [SQL Server], certificates CERT_ID function IDs [SQL Server], certificates certificates [SQL Server], IDs
ms.assetid	59cc06f5-272e-4936-8afe-afba7aba8eea
caps.latest.revision	23
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

CERT_ID (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

This function returns the ID value of a certificate.

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