SELECT
TBNAME,
NAME,
TBCREATOR,
COLTYPE,
NULLS,
LENGTH,
SCALE
FROM SYSIBM.SYSCOLUMNS
WHERE
TBCREATOR = 'MYSCHEMA'
order by TBNAME
SELECT
TBNAME,
NAME,
TBCREATOR,
COLTYPE,
NULLS,
LENGTH,
SCALE
FROM SYSIBM.SYSCOLUMNS
WHERE
TBCREATOR = 'MYSCHEMA'
order by TBNAME