How to view the fields of a table and their descriptions and export them as a table without using the SHOW statement

Translated
1

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

Original topic: 如何查看一个表的字段及其字段描述等信息并导出为一个table, 不使用show语句

| username: TiDBer_rYOSh9JN

To view the fields of a table and their descriptions and export them as a table without using the SHOW statement.

2
| username: 啦啦啦啦啦 | Original post link

Just look directly at the COLUMNS table under information_schema
select * from information_schema.COLUMNS where table_name='xxx';

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

You can use the Navicat tool to click on the target table, and the right side will display the table creation statement.

image
image1292×723 54.6 KB

4
| username: TiDBer_rYOSh9JN | Original post link

SHOW COLUMNS FROM table;

5
| username: 啦啦啦啦啦 | Original post link

Isn’t this still a show~

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

There is a suspicion of point fraud.

7
| username: zhanggame1 | Original post link

This is actually also shown.

8
| username: Fly-bird | Original post link

You can check it in the information_schema, right?

9
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.