db2数据库查看列名中文解释
2019-01-09 本文已影响2人
有寻_
DB2 查询 某个schma下(cif)某个表(cif_info)所有列注释
用以下sql:
select t.remarks as 注释,t.* from syscat.COLUMNS t where tabschema='CIF' and tabname=upper('cif_info')
DB2 查询 某个schma下(cif)某个表(cif_info)所有列注释
用以下sql:
select t.remarks as 注释,t.* from syscat.COLUMNS t where tabschema='CIF' and tabname=upper('cif_info')