Re: Find Empty Tables

andrewst wrote:

> Seems a bit rough to
> criticise Andy for using EXISTS properly just because you have known
> others to use it improperly!

Hey, hey.. not so loud so early in the morning before I had my first cup of coffee. :-)

I still don't see the reason to use an EXIST when a FIRST_ROWS does it, if not faster, then as fast.

> I have also known people to use COUNT(*)
> improperly (like WITHOUT your ROWNUM=1 restriction to check for
> existence):

I know people who still think that you need to process a table like a ISAM or VSAM file. Can we swap developers? ;-)

> shall I take a lead pipe to you ;-)

I insist. If I get my feet down the gullet, I want a hard whack or two to get them dislodged.

--
Billy