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

Translated
1

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?

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

Doesn’t the table have dbname and tablename fields?

3
| username: jiayou64 | Original post link

image
image992×613 16.4 KB

4
| username: jiayou64 | Original post link

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