title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

monikerRange

sys.key_encryptions (Transact-SQL)

rwestMSFT

randolphwest

07/18/2017

sql

system-objects

reference

sys.key_encryptions

key_encryptions_TSQL

sys.key_encryptions_TSQL

key_encryptions

sys.key_encryptions catalog view

TSQL

=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.key_encryptions (Transact-SQL)

Returns a row for each symmetric key encryption specified by using the ENCRYPTION BY clause of the CREATE SYMMETRIC KEY statement.

Column names	Data types	Description
key_id	int	ID of the encrypted key.
thumbprint	varbinary(32)	SHA-1 hash of the certificate with which the key is encrypted, or the GUID of the symmetric key with which the key is encrypted.
crypt_type	char(4)	Type of encryption: ESKS = Encrypted by symmetric key ESKP, ESP2, or ESP3 = Encrypted by password EPUC = Encrypted by certificate EPUA = Encrypted by asymmetric key ESKM = Encrypted by master key
crypt_type_desc	nvarchar(60)	Description of encryption type: ENCRYPTION BY SYMMETRIC KEY ENCRYPTION BY PASSWORD (Beginning with [!INCLUDE sssql17-md], includes a version number for use by CSS.) ENCRYPTION BY CERTIFICATE ENCRYPTION BY ASYMMETRIC KEY ENCRYPTION BY MASTER KEY Note: Windows DPAPI is used to protect the service master key.
crypt_property	varbinary(max)	Signed or encrypted bits.

Permissions