title: "sys.key_encryptions (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "07/18/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" 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: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!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, 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 [!INCLUDEsssqlv14_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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
CREATE SYMMETRIC KEY (Transact-SQL)