Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance
This catalog view returns information about encryption keys that are open in the current session.
|Column name||Data type||Description|
|database_id||int||ID of the database that contains the key.|
|database_name||sysname||Name of the database that contains the key.|
|key_id||int||ID of the key. The ID is unique within the database.|
|key_name||sysname||Name of the key. Unique within the database.|
|key_guid||varbinary||GUID of the key. Unique within the database.|
|opened_date||datetime||Date and time when the key was opened.|
|status||int||1 if the key is valid in metadata. 0 if the key is not found in metadata.|
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.