cert-id-transact-sql.md

title	CERT_ID (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	07/24/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
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	BYHAM
ms.author	rickbyh
manager	jhubbard

CERT_ID (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

Returns the ID of a certificate.

Transact-SQL Syntax Conventions

Syntax

Cert_ID ( 'cert_name' )  

Arguments

' cert_name '
Is the name of a certificate in the database.

Return types

int

Remarks

Certificate names are visible in the sys.certificates catalog view.

Permissions

Requires some permission on the certificate and that the caller has not been denied VIEW DEFINITION permission on the certificate.

Examples

The following example returns the ID of a certificate called ABerglundCert3.

SELECT Cert_ID('ABerglundCert3');  
GO  

See also

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