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'