达梦数据库 查询建表语句、获取字段注释（亲测可用）

-- 查询建表语句（大写）
SELECT dbms_metadata.get_ddl('TABLE', 'XX') AS DDL_STATEMENT
FROM dual;-- 获取字段注释（大写）
SELECT 'COMMENT ON COLUMN ' || TABLE_NAME || '.' || COLUMN_NAME ||' IS ''' || COMMENTS || ''';' AS COMMENT_STATEMENT
FROM USER_COL_COMMENTS
WHERE TABLE_NAME = 'XX'AND COMMENTS IS NOT NULL;