Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All



Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the algorithm of a symmetric key created from an EKM module.

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

Topic link icon Transact-SQL Syntax Conventions

SYMKEYPROPERTY ( Key_ID , 'algorithm_desc' | 'string_sid' | 'sid' )


Is the Key_ID of a symmetric key in the database. To find the Key_ID when you only know the key name, use SYMKEY_ID. Key_ID is data type int.


Specifies that the output returns the algorithm description of the symmetric key. Only available for symmetric keys created from an EKM module.


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

The following example returns the algorithm of the symmetric key with Key_ID 256.

SELECT SYMKEYPROPERTY(256, 'algorithm_desc') AS Algorithm ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft