Re: A query to return row counts of all tables in cat

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 1 Dec 2006 07:12:16 +0100
Message-ID: <456fc7c0$0$29587$426a74cc@news.free.fr>

<erich.pearson_at_att.net> a écrit dans le message de news: 1164919681.775740.168680_at_f1g2000cwa.googlegroups.com...
| 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
|

http://www.dba-village.com/village/dvp_tips.TipDetails?TipIdA=1878

Regards
Michel Cadot Received on Fri Dec 01 2006 - 00:12:16 CST