sys.openkeys (Transact-SQL)
New: 14 April 2006
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. |
See Also
Reference
OPEN SYMMETRIC KEY (Transact-SQL)