How to find tables with no rows in a database

Neharao · #1 (**permalink**) 03-17-10, 08:39

Hello all

In a database how to know the list tables with 0 rows. ( Count(*) = 0)

Can we achieve this in a single query

Thank You
Kalyani Ch

ARWinner · #2 (**permalink**) 03-17-10, 09:02

Sure, if your runstats are current:

Code:

select tabschema,tabname from syscat.tables where card = 0

Andy

Cougar8000 · #3 (**permalink**) 03-17-10, 10:10

Yes, but only if stats were collected. Other wise I would write a shell loop to go after all tables.

Neharao · #4 (**permalink**) 03-17-10, 10:36

Thank You. It worked