.png)
sys.openkeys (Transact-SQL)
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. |
