select
creator,
type,
name,
colcount,
card
from sysibm.systables
where creator = 'schema_name';
select
tbcreator,
tbname,
name,
coltype,
colno
from
sysibm.syscolumns
where
tbcreator = 'schema_name'
and tbname = 'table_name'
order by colno;