ORACLE
SELECT
t.COLUMN_NAME 列名,--字段名称
t.DATA_TYPE 数据类型,--字典类型
t.DATA_LENGTH 长度,--字典长度
t.NULLABLE 是否为空,--是否为空
c.comments 注释 --字段注释
FROM
user_tab_columns t
INNER JOIN user_col_comments c ON t.TABLE_NAME = c.table_name
AND t.COLUMN_NAME = c.column_name
WHERE
t.Table_Name = 'CENSORTASKS' --要查询的数据库表名称
ORDER BY
t.column_name
MYSQL
SELECT
COLUMN_NAME AS '字段名',
DATA_TYPE AS `数据类型`,
CHARACTER_MAXIMUM_LENGTH AS `字符长度`,
NUMERIC_PRECISION AS `数字长度`,
NUMERIC_SCALE AS `小数位数`,
IS_NULLABLE AS `是否允许非空`,
CASE
WHEN EXTRA = 'auto_increment' THEN
1 ELSE 0
END AS `是否自增`,
COLUMN_DEFAULT AS `默认值`,
COLUMN_COMMENT AS `备注`
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'hussar821beta5' --数据库名称/表空间
AND TABLE_NAME = 'bpm_act_config';--要查询数据库表名称
导出结果两种方法:
navicat工具导出结果(oracle为例)
一选择制表符分隔值(字段名和数据)复制到EXCEL文件中即可或者点击上方的导出结果按钮,一键到底。
二导出结果