使用mysq的information_schema导出字典

#mysql

SELECT
TABLE_NAME as 表名,
COLUMN_NAME as 列名,
IS_NULLABLE as 是否可空,
DATA_TYPE as 数据类型,
COLUMN_TYPE as 字段长度,
COLUMN_KEY  as 是否主键 ,
COLUMN_COMMENT as 注释
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = '你的数据库名称'
order by TABLE_SCHEMA asc

 

#oracle

SELECT
    A.TABLE_NAME AS "表名",
    A.COLUMN_NAME AS "字段名",
    DECODE(
    A.CHAR_LENGTH,
    0,
    DECODE(
    A.DATA_SCALE,
    NULL,
    A.DATA_TYPE,
    A.DATA_TYPE || '(' || A.DATA_PRECISION || ',' || A.DATA_SCALE || ')' 
    ),
    A.DATA_TYPE || '(' || A.CHAR_LENGTH || ')' 
    ) AS "字段类型",
    A.DATA_DEFAULT AS "默认值",
    A.NULLABLE AS "能否为空",
    B.comments AS "备注" 
FROM
    sys.user_tab_columns A,
    sys.user_col_comments B 
WHERE
    A.table_name = B.table_name 
    AND A.COLUMN_NAME = B.COLUMN_NAME 

ORDER BY
    A.TABLE_NAME;