select tabname,card from syscat.tables where tabschema = 'you table schema'
syscat.tables查询出来的字段还有很多,具体字段解释在IBM官网有:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_8.2.0/com.ibm.db2.udb.doc/admin/r0001063.htm
select tabname,card from syscat.tables where tabschema = 'you table schema'
syscat.tables查询出来的字段还有很多,具体字段解释在IBM官网有:
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_8.2.0/com.ibm.db2.udb.doc/admin/r0001063.htm