Is there any way to retrieve table metadata using select rather than show?

[吴朱华]

Hi guys:

Currently, we are using "show databases","show tables" or "Describe table"
to retrieve table metadata, but we use such as "select * from metadata" to
retrieve, just like RDBMS did^_^