sys.column_encryption_keys (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2016)noAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

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

||
|-|
|Applies to: SQL Server ( SQL Server 2016 through current version), SQL Database.|

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.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 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)