Answer
可以使用下面的SQL查询相关信息:
db2 "SELECT SUBSTR(A.TABSCHEMA,1,30) TABSCHEMA,
SUBSTR(A.TABNAME,1, 30) TABNAME,
SUBSTR(A.COLNAME,1,30) COLNAME,
A.IDENTITY,
CASE
WHEN A.GENERATED='A' THEN 'GENERATED ALWAYS'
WHEN A.GENERATED='D' THEN 'GENERATED BY DEFAULT'
ELSE ' '
END GENERATED,
SUBSTR(C.SEQSCHEMA,1,30) SEQSCHEMA,
SUBSTR(C.SEQNAME,1,30) SEQNAME,
C.NEXTCACHEFIRSTVALUE
FROM SYSCAT.COLUMNS A
INNER JOIN SYSCAT.COLIDENTATTRIBUTES B
ON A.TABSCHEMA=B.TABSCHEMA AND
A.TABNAME=B.TABNAME
INNER JOIN SYSCAT.SEQUENCES C
ON B.SEQID=C.SEQID
WHERE A.GENERATED IN('A','D') WITH UR"
示例输出:
TABSCHEMA TABNAME COLNAME IDENTI