sys-column-encryption-key-values-transact-sql.md

title	sys.column_encryption_key_values (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
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
applies_to	Azure SQL Database SQL Server 2016 Preview
f1_keywords	column_encryption_key_values column_encryption_key_values_TSQL sys.column_encryption_key_values sys.column_encryption_key_values_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.column_encryption_key_values catalog view
ms.assetid	440875ab-b0e9-4966-8c16-01503558fedd
caps.latest.revision	12
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.column_encryption_key_values (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Returns information about encrypted values of column encryption keys (CEKs) created with either the CREATE COLUMN ENCRYPTION KEY or the ALTER COLUMN ENCRYPTION KEY (Transact-SQL) statement. Each row represents a value of a CEK, encrypted with a column master key (CMK).

Column name	Data type	Description
column_encryption_key_id	int	ID of the CEK in the database.
column_master_key_id	int	ID of the column master key that was used to encrypt the CEK value.
encrypted_value	varbinary(8000)	CEK value encrypted with the CMK specified in column_master_key_id.
encryption_algorithm_name	sysname	Name of an algorithm used to encrypt the CEK value. Name of the encryption algorithm used to encrypt the value. The algorithm for the system providers must be RSA_OAEP.

Permissions

Requires the VIEW ANY COLUMN ENCRYPTION KEY permission.

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

See Also

CREATE COLUMN ENCRYPTION KEY (Transact-SQL)
ALTER COLUMN ENCRYPTION KEY (Transact-SQL)
DROP COLUMN ENCRYPTION KEY (Transact-SQL)
CREATE COLUMN MASTER KEY (Transact-SQL)
Security Catalog Views (Transact-SQL)
sys.column_encryption_keys (Transact-SQL)
sys.column_master_keys (Transact-SQL)
sys.columns (Transact-SQL)
Always Encrypted (Database Engine)