达梦数据库导出表结构excel

SELECT d.name AS 模式名,
c.name AS 表名,
e."COMMENT$" AS 表描述,
a."NAME" AS 字段名,
b."COMMENT$" AS 字段描述,
a."TYPE$" AS 字段类型,
a."LENGTH$" AS 字段长度,
a."SCALE" AS 小数位,
DECODE(a."NULLABLE$", 'Y', '是', 'N', '否') AS "是否允许为空"
FROM "SYS"."SYSCOLUMNS" a
LEFT JOIN "SYS"."SYSOBJECTS" c ON c.TYPE$='SCHOBJ' AND c.subtype$='UTAB' AND a.id = c.id
LEFT JOIN "SYS"."SYSOBJECTS" d ON d.TYPE$='SCH' AND c.schid = d.id
LEFT JOIN "SYS"."SYSCOLUMNCOMMENTS" b ON d.name = b.schname AND c.name = b.tvname AND a.name = b.colname
LEFT JOIN "SYS"."SYSTABLECOMMENTS" e ON d.name = e.schname AND c.name = e.tvname AND e.table_type='TABLE'
WHERE d.name = 'HSE_OVERSEA_HEALTH' and c.name like 'XXXX%' -- 替换为实际模式名
ORDER BY d.name, c.name, a.colid ASC;

模式名就是数据库名