sys-key-encryptions-transact-sql.md

title	sys.key_encryptions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.key_encryptions key_encryptions_TSQL sys.key_encryptions_TSQL key_encryptions
dev_langs	TSQL
helpviewer_keywords	sys.key_encryptions catalog view
ms.assetid	c39cecf8-af63-40b9-98e5-f84a5bf3ae54
caps.latest.revision	22
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.key_encryptions (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

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 = 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 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

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
CREATE SYMMETRIC KEY (Transact-SQL)