sys.openkeys (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database

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 has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Encryption Hierarchy
OPEN SYMMETRIC KEY (Transact-SQL)