MySQL
MySQL
数据库可以利用information_schema
库中的columns
表快速导出数据字典。
执行以SQL
语句即可对数据字典进行查询:
SELECTTABLE_SCHEMA AS '数据库名',TABLE_NAME AS '表名',COLUMN_NAME AS '列名',COLUMN_TYPE AS '类型',COLUMN_DEFAULT AS '默认值',IS_NULLABLE AS '允许为空',DATA_TYPE AS '数据类型',CHARACTER_MAXIMUM_LENGTH AS '字符最大长度',NUMERIC_PRECISION AS '数字精度',NUMERIC_SCALE AS '小数位数',COLUMN_COMMENT AS '字段说明' FROMinformation_schema.COLUMNS WHERETABLE_SCHEMA = 'db_name'
字段说明
columns
表中的字段说明,按需取用: