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.|
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.
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)