How to find the corresponding schema based on schema_id in information_schema.ddl_jobs

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何根据information_schema.ddl_jobs 的schema_id ,查出对应的schema

| username: TiDBer_rdb3y58G

How to find the corresponding schema based on the schema_id in information_schema.ddl_jobs?

| username: 像风一样的男子 | Original post link

Doesn’t the table have dbname and tablename fields?

| username: jiayou64 | Original post link

| username: jiayou64 | Original post link

SHOW SCHEMAS is an alias for the SHOW DATABASES statement.”