sys.column_encryption_keys (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database yesAzure 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.

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)