sys.column_encryption_keys (Transact-sql) sys.column_encryption_keys (Transact-SQL)
SQL Server 2016 和更新版本 
Azure SQL Database
Azure Synapse Analytics
平行處理資料倉儲
傳回資料行加密金鑰的相關資訊 (使用 CREATE COLUMN ENCRYPTION KEY 語句建立的 cek) 。Returns information about column encryption keys (CEKs) created with the CREATE COLUMN ENCRYPTION KEY statement. 每個資料列都代表 CEK。Each row represents a CEK.
| 資料行名稱Column name | 資料類型Data type | 描述Description |
|---|---|---|
| namename | sysnamesysname | CEK 的名稱。The name of the CEK. |
| column_encryption_key_idcolumn_encryption_key_id | intint | CEK 的識別碼。ID of the CEK. |
| create_datecreate_date | datetimedatetime | CEK 的建立日期。Date the CEK was created. |
| modify_datemodify_date | datetimedatetime | 上次修改 CEK 的日期。Date the CEK was last modified. |
權限Permissions
需要 VIEW ANY COLUMN ENCRYPTION KEY 許可權。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. 如需相關資訊，請參閱 Metadata Visibility Configuration。For more information, see Metadata Visibility Configuration.
另請參閱See Also
CREATE COLUMN ENCRYPTION KEY (Transact-SQL) CREATE COLUMN ENCRYPTION KEY (Transact-SQL)
ALTER COLUMN ENCRYPTION KEY (Transact-SQL) ALTER COLUMN ENCRYPTION KEY (Transact-SQL)
DROP COLUMN ENCRYPTION KEY (Transact-SQL) DROP COLUMN ENCRYPTION KEY (Transact-SQL)
CREATE COLUMN MASTER KEY (Transact-SQL) CREATE COLUMN MASTER KEY (Transact-SQL)
安全性目錄檢視 (Transact-SQL) Security Catalog Views (Transact-SQL)
sys.column_encryption_key_values (Transact-SQL)sys.column_encryption_key_values (Transact-SQL)
Always Encrypted Always Encrypted
具有安全記憶體保護區的 Always Encrypted Always Encrypted with secure enclaves
Always Encrypted 的金鑰管理概觀 Overview of Key Management for Always Encrypted
為具有安全記憶體保護區的 Always Encrypted 管理金鑰Manage keys for Always Encrypted with secure enclaves