Forum

Hallo Zefrim,

wie wäre es mit

SELECT TB.CREATOR, TB.NAME, COUNT(IX.NAME)
FROM SYSIBM.SYSTABLES TB
,SYSIBM.SYSINDEXES IX
WHERE TB.TYPE = ‚T‘
AND TB.CREATOR = IX.TBCREATOR
AND TB.NAME = IX.TBNAME
GROUP BY TB.CREATOR, TB.NAME
;

Tschüß
Christian