sys.openkeys (Transact-SQL)
Applies to: 
SQL Server
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. |
Permissions
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
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