使用Navicat导出MySQL数据库的数据字典

1、SQL语句

Mysql数据库导出数据字典：

SELECT
	TABLE_SCHEMA as '数据库名称',
	TABLE_NAME as '表字段名',
	COLUMN_NAME as '列字段名',
	COLUMN_TYPE as '列字段类型',
	COLUMN_KEY as '字段约束类型',
	EXTRA as '字段自增',
	IS_NULLABLE as '是否为空',
	COLUMN_COMMENT as '字段说明'
FROM
	information_schema. COLUMNS
WHERE
	TABLE_SCHEMA = 'database_name';

Mysql查询某列名(column_name)所在的数据库表名(table_name)

SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'column_name';

2、使用示例

参考：https://www.youkuaiyun.com/gather_24/MtTaIg1sMjI5OC1ibG9n.html