达梦 获取表名注释、表结构及主键

   SELECT a.table_name
        , c.comments
        , a.column_name
        , b.comments
        , a.data_type
        , a.data_length
        , a.data_precision
        , a.data_scale
        , d.column_position
     FROM all_tab_cols                  a
LEFT JOIN all_col_comments              b
       ON b.table_name  = a.table_name
      AND b.column_name = a.column_name
      AND a.owner       = b.owner
LEFT JOIN all_tab_comments              c
       ON c.table_name = b.table_name
      AND c.owner      = b.owner
LEFT JOIN
          ( SELECT dcc.table_name
                , dcc.column_name
                , dcc.column_position
                , dcc.index_owner
             FROM all_ind_columns       dcc
             JOIN all_constraints       dc
               ON dcc.index_name     = dc.index_name
              AND dc.constraint_type = UPPER('p')
              AND dcc.index_owner    = dc.owner
          )                             d
       ON d.table_name  = b.table_name
      AND d.column_name = b.column_name
      AND d.index_owner = a.owner
    WHERE a.owner       = UPPER('SZYJSRF')     --表的拥有者
      AND a.table_name IN ('NDRKXXB_OD330916') --表名
 ORDER BY a.table_name
        , a.column_id ASC 
;