A query to return row counts of all tables in cat

I'm trying to craft a query that will return all the tables listed in cat, along with the row count of each. Something like this:

TABLE_NAME     COUNT(*)
---------------------      -------------
TEST                   2257
CYCLE                  308
ACTIONS             6593

I tried:

SELECT TABLE_NAME, COUNT(*) FROM(SELECT TABLE_NAME FROM CAT) GROUP BY TABLE_NAME; but it just returns 1 for the row count.

Is this even possible to do without programming? Can someone please help me out?

Thanks!
Erich Pearson Received on Thu Nov 30 2006 - 14:48:01 CST