Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure Synapse Analytics
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 CEK. |
| 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 was granted some permission. For more information, see Metadata Visibility Configuration.
Related content
- 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_key_values (Transact-SQL)
- Always Encrypted
- Always Encrypted with secure enclaves
- Overview of key management for Always Encrypted
- Manage keys for Always Encrypted with secure enclaves