达梦数据库导出数据表结构为excel或html或文本

一、基础版本

select 
	utc.column_name 字段名,
	utc.data_type 字段类型,
	utc.data_length 数据长度,
	utc.data_precision 数据精度,
	utc.nullable 是否为空 ,
	ucc.comments 备注
from user_tab_columns utc,user_col_comments ucc
where utc.column_name = ucc.column_name and utc.Table_Name = ucc.Table_Name 
and utc.Table_Name = '表名' and owner='模式名'

二、优化版本

select 
utc.Table_Name 表名称,
tab.COMMENTS 表中文名称,
	utc.column_name AS 字段名,
	utc.data_type AS 字段类型,
	utc.data_length AS 数据长度,
	utc.data_precision AS 数据精度,
	utc.nullable AS 是否为空 ,
	ucc.comments AS 备注
from user_tab_columns utc,user_col_comments ucc,SYS.USER_TAB_COMMENTS tab
where utc.column_name = ucc.column_name and utc.Table_Name = ucc.Table_Name 
and utc.Table_Name = tab.TABLE_NAME
and owner='RTEMS';

任意位置右击导出