CERT_ID (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
This function returns the ID value of a certificate.
Transact-SQL syntax conventions
Syntax
CERT_ID ( 'cert_name' )
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
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
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za