sys.column_encryption_keys (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions 
Azure SQL Database
Azure Synapse Analytics
Analytics Platform System (PDW)
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.
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)
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
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for