Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

ASYMKEY_ID (Transact-SQL)

Updated: March 16, 2015

Returns the ID of an asymmetric key.

Applies to: SQL Server (SQL Server 2008 through current version), SQL Database V12 (Preview in some regions).

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.

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

Community Additions

Show:
© 2015 Microsoft