| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SYMKEYPROPERTY (Transact-SQL) |
SYMKEYPROPERTY (Transact-SQL) |
VanMSFT |
vanto |
03/06/2017 |
sql |
t-sql |
reference |
|
|
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
Returns the algorithm of a symmetric key created from an EKM module.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
SYMKEYPROPERTY ( Key_ID , 'algorithm_desc' | 'string_sid' | 'sid' )
[!INCLUDEsql-server-tsql-previous-offline-documentation]
Key_ID
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.
'algorithm_desc'
Specifies that the output returns the algorithm description of the symmetric key. Only available for symmetric keys created from an EKM module.
sql_variant
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 ;
GO ASYMKEY_ID (Transact-SQL)
ALTER SYMMETRIC KEY (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
Encryption Hierarchy
sys.symmetric_keys (Transact-SQL)
Security Catalog Views (Transact-SQL)
KEY_ID (Transact-SQL)
ASYMKEYPROPERTY (Transact-SQL)