Thread: Re: Check if table exists

Re: Check if table exists

From
"Guy Rouillier"
Date:
ON.KG wrote:
> Hi ALL!
>
> I need to check before selection records from table - does this table
> exist How can i do that?

One thing to consider: you are making a trip to the database to
determine if a table exists.  If it exists, you are then making another
trip to the database to get rows from it.  For a non-destructive
operation (i.e., select), you may be better off just doing the select,
and watching for a "table does not exist" error.

--
Guy Rouillier