1、navicat导出数据库字典
select TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where TABLE_SCHEMA='数据库名'
2、navicat提取数据库SQL
1、新建备份
2、从备份上提取sql(鼠标右击备份)
参考:
导出字典:https://jingyan.baidu.com/article/5225f26ba8a5f2e6fa0908ac.html