Navicat导出数据字典

#新建一个查询把下面的代码放进去执行
SELECT
    t.TABLE_SCHEMA AS '库名称',
    t.TABLE_NAME AS '表名',
    t.COLUMN_NAME AS '字段名',
    t.COLUMN_TYPE AS '字段类型',
IF
    ( t.COLUMN_DEFAULT = '', '空字符串', IFNULL( t.COLUMN_DEFAULT, '无' ) ) AS '默认值',
    t.COLUMN_COMMENT AS '字段备注'
FROM
    information_schema.COLUMNS t
WHERE
     TABLE_SCHEMA = '你的数据库名字'

然后导出为word或excel即可