DB2查询表名，字段名

留下来备忘。

DB2查询表名，字段名

SELECT
    C.TABSCHEMA,
    C.TABNAME,
    C.COLNAME
FROM
    SYSCAT.TABLES AS T,
    SYSCAT.COLUMNS AS C
WHERE
    T.TBSPACEID = 2--表空间ID

AND T.TABLEID = 4120--表ID

AND C.COLNO = 13--字段号

AND C.TABSCHEMA = T.TABSCHEMA
AND C.TABNAME = T.TABNAME