ASYMKEY_ID (Transact-SQL)

ASYMKEY_ID (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the ID of an asymmetric key.

Topic link icon Transact-SQL Syntax Conventions

  
ASYMKEY_ID ( 'Asym_Key_Name' )  

Asym_Key_Name
Is the name of an asymmetric key in the database.

int

Requires some permission on the asymmetric key and that the caller has not been denied VIEW permission on the asymmetric key.

The following example returns the ID of asymmetric key ABerglundKey11.

SELECT ASYMKEY_ID('ABerglundKey11');  
GO  

CREATE ASYMMETRIC KEY (Transact-SQL)
ALTER ASYMMETRIC KEY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
SIGNBYASYMKEY (Transact-SQL)
VERIFYSIGNEDBYASYMKEY (Transact-SQL)
Encryption Hierarchy
sys.asymmetric_keys (Transact-SQL)
Security Catalog Views (Transact-SQL)
ASYMKEYPROPERTY (Transact-SQL)
KEY_ID (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft