sys-column-encryption-keys-transact-sql.md

title	sys.column_encryption_keys (Transact-SQL) | Microsoft Docs
ms.custom	SQL2016_New_Updated
ms.date	10/28/2015
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	Azure SQL Database SQL Server 2016 Preview
f1_keywords	sys.column_encryption_keys column_encryption_keys_TSQL sys.column_encryption_keys_TSQL column_encryption_keys
dev_langs	TSQL
helpviewer_keywords	sys.column_encryption_keys catalog view
ms.assetid	43980dd8-b9b1-4869-a304-2c183ae8977d
caps.latest.revision	9
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.column_encryption_keys (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-xxx_md]

Returns information about column encryption keys (CEKs) created with the CREATE COLUMN ENCRYPTION KEY statement. Each row represents a CEK.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssSQL15] through current version), [!INCLUDEsqldbesa].

Column name	Data type	Description
name	sysname	The name of the CMK.
column_encryption_key_id	int	ID of the CEK.
create_date	datetime	Date the CEK was created.
modify_date	datetime	Date the CEK was last modified.

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)
Always Encrypted (Database Engine)
sys.column_encryption_key_values (Transact-SQL)