SHOW ENCRYPTKEY

Description

View all custom keys under the database. If the user specifies a database, check the corresponding database, otherwise directly query the database where the current session is located.

Syntax

SHOW ENCRYPTKEYS [ { IN | FROM } <db> ] [ LIKE '<key_pattern>']

Optional Parameters

1. <db>

Name of the target database.
Example: db1 (in key names like db1.my_key).

2. <key_pattern>

Pattern parameter for filtering key names (supports wildcard matching).

Return Value

Column	Description
`EncryptKey Name`	Name of the key
`EncryptKey String`	Value of the key

Access Control Requirements

The user executing this SQL command must have the following minimum privileges:

Privilege	Object	Notes
`ADMIN_PRIV`	User / Role	Must hold the `ADMIN_PRIV` privilege on the target user/role to view encryption keys

Usage Notes

If a database is explicitly specified, the system will query encryption keys within the designated database. Otherwise, it automatically queries keys in the current session's database.

Example

List all custom keys in the current session's database.

SHOW ENCRYPTKEYS;

+-----------------+-------------------+
| EncryptKey Name | EncryptKey String |
+-----------------+-------------------+
| testdb.test_key | ABCD123456789     |
+-----------------+-------------------+

List all custom keys in a specified database.

SHOW ENCRYPTKEYS FROM example_db ;

+---------------------+-------------------+
| EncryptKey Name     | EncryptKey String |
+---------------------+-------------------+
| example_db.my_key   | ABCD123456789     |
| example_db.test_key | ABCD123456789     |
+---------------------+-------------------+

Filter keys by name pattern in a specified database.

SHOW ENCRYPTKEYS FROM example_db LIKE "%my%";

+-------------------+-------------------+
| EncryptKey Name   | EncryptKey String |
+-------------------+-------------------+
| example_db.my_key | ABCD123456789     |
+-------------------+-------------------+

DROP FILE SHOW FILE