DB2数据库查询表、列注释

--查询列注释
select colname, remarks from SYSCAT.COLUMNS where tabname = '表名[大写]'

--查询表注释
select TABNAME,remarks from SYSCAT.TABLES where tabname = '表名[大写]'

--查询主键
SELECT K.COLNAME AS 主键名 FROM SYSCAT.KEYCOLUSE K WHERE TABNAME='表名[大写]'