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

Syntax


ASYMKEY_ID ( 'Asym_Key_Name' )  

Arguments

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

Return Types

int

Permissions

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

Examples

The following example returns the ID of asymmetric key ABerglundKey11.

SELECT ASYMKEY_ID('ABerglundKey11');  
GO  

See Also

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)