Joined: 14 Oct 2005 Posts: 1188 Location: Bangalore,India
If you want to count the number of rows ine ach table where creator ='ABCD' then u can use following query
WHERE CREATOR LIKE 'ABCD%' WITH UR;
CRADF definesTotal number of rows in the table or total number of LOBs in an auxiliary table. The value is -1 if statistics have not been gathered or the row describes a view, alias, or created temporary table. This is an updatable column.
OR If u want total number of table for which CREATOR is 'ABCD' then u can use query given by Ashmir
SELECT COUNT(NAME) FROM SYSIBM.SYSTABLES WHERE CREATOR='ABCD' with ur;