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. |
Permissions
In SQL Server 2005 and later versions, 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.