使用navicat导出mariadb字典

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、显示。