Selecting all tables with no records
Posted
by sqlgrasshopper5
on Stack Overflow
See other posts from Stack Overflow
or by sqlgrasshopper5
Published on 2010-05-17T10:56:54Z
Indexed on
2010/05/17
11:01 UTC
Read the original article
Hit count: 96
I need to display all tables that have zero records.
I tried,
select * from user_all_tables where (select count(*) from user_all_tables)=0;
But it doesn't seem to work. How should I go about redesigning this query? Thanks.
© Stack Overflow or respective owner
