sys.openkeys (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)