DB2系统表

 1】查表名

select tabschema,
       tabname,
       remarks,
       create_time,
       alter_time,
       colcount,
       keycolumns,
       keyindexid,
       keyunique,
       property
from SYSCAT.TABLES
WHERE TABSCHEMA = 'xxx'
-- and remarks like '%测试%'
and tabname ='test_table';

2】查列名

select tabname,
       colname,
       remarks,
       typename,
       length
from SYSCAT.COLUMNS
WHERE tabname = 'test_table'