January 31, 2008 at 1:55 pm
Guys,
Is there any sql to spit out tables from 400 tables in database which have 0 rows.
Any suggestions and inputs would help
Thanks
January 31, 2008 at 2:09 pm
Are you trying to create blank copies of existing tables (that have rows) or ar you trying to find those with NO rows among a total of 400?
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 31, 2008 at 2:24 pm
Are you trying to find out which tables in a database have 0 rows? (Not sure from the wording of your question.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 31, 2008 at 10:57 pm
if you are trying to find all tables in database with zero row count, you have to write a program which runs a query to find row count for each table and based on row count, you take required actions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply