编写数据库设计文档的小技巧

编写数据库设计文档的小技巧

mysql

SELECT
 COLUMN_NAME 英文名称,
 COLUMN_TYPE 数据类型,
 COLUMN_COMMENT 注释,
 '无' 备注
FROM
 INFORMATION_SCHEMA.COLUMNS 
WHERE
 table_schema = 'tax_interview' --数据库名
 AND table_name = 'interview' --表名

执行结果如下：

oracle

select 
	a.owner "模式",
	a.table_name "表名",
	a.column_name "列名",
	a.data_type "数据类型",
	a.data_length "长度",
	a.nullable "非空",
	b.comments "注释"
from all_tab_columns a 
left join all_col_comments b on a.owner = b.owner and a.table_name = b.table_name and a.column_name = b.column_name
where a.owner = 'MZJCSHZL' 
	and a.table_name = 'BASE_ROLE'
order by a.table_name, a.column_id

执行结果如下：