利用系统数据库
例如:
select remarks from SYSIBM.SYSCOLUMNS where tbname='aaa';
SYSIBM.SYSCOLUMNS
NAME 字段名
TBNAME 表名
TBCREATOR 表Schema
REMARKS Comments
COLTYPE 字段类型
NULLS 是否可为NULL
CODEPAGE
DBCSCODEPG
LENGTH 字段长度
SCALE 精确范围
COLNO 字段序号
COLCARD
HIGH2KEY
LOW2KEY
AVGCOLLEN
KEYSEQ
TYPENAME 字段类型全称
TYPESCHEMA 类型Schema?
DEFAULT 默认值
LONGLENGTH Long型长度
LOGGED
COMPACT
NQUANTILES
NMOSTFREQ
COMPOSITE_CODEPAGE
PARTKEYSEQ
SOURCE_TABSCHEMA
SOURCE_TABNAME
HIDDEN
GENERATED 权限
INLINE_LENGTH
NUMNULLS
AVGCOLLENCHAR
SUB_COUNT
SUB_DELIM_LENGTH
IDENTITY
COMPRESS
AVGDISTINCTPERPAGE
PAGEVARIANCERATIO
IMPLICITVALUE
SECLABELID
COLLATIONID
PCTINLINED
待完善......
例如:
select remarks from SYSIBM.SYSCOLUMNS where tbname='aaa';
SYSIBM.SYSCOLUMNS
NAME 字段名
TBNAME 表名
TBCREATOR 表Schema
REMARKS Comments
COLTYPE 字段类型
NULLS 是否可为NULL
CODEPAGE
DBCSCODEPG
LENGTH 字段长度
SCALE 精确范围
COLNO 字段序号
COLCARD
HIGH2KEY
LOW2KEY
AVGCOLLEN
KEYSEQ
TYPENAME 字段类型全称
TYPESCHEMA 类型Schema?
DEFAULT 默认值
LONGLENGTH Long型长度
LOGGED
COMPACT
NQUANTILES
NMOSTFREQ
COMPOSITE_CODEPAGE
PARTKEYSEQ
SOURCE_TABSCHEMA
SOURCE_TABNAME
HIDDEN
GENERATED 权限
INLINE_LENGTH
NUMNULLS
AVGCOLLENCHAR
SUB_COUNT
SUB_DELIM_LENGTH
IDENTITY
COMPRESS
AVGDISTINCTPERPAGE
PAGEVARIANCERATIO
IMPLICITVALUE
SECLABELID
COLLATIONID
PCTINLINED
待完善......