1、新建查询。
2、运行sql语句。
SELECT
TABLE_NAME AS '表名',
COLUMN_NAME AS '字段名',
COLUMN_TYPE AS '数据类型',
IS_NULLABLE AS '允许为空',
COLUMN_COMMENT AS '字段说明'
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = '数据库名称'
3、导出结果。
4、显示。