Re: Testing a table existence

You want to look in the user_tables something like this:

myVariable:=0;
select count(*) into myVariable from user_tables where table_name='MYTABLE'; if myVariable>0 then
...
end if;

Jim

"Sylvain BOURDETTE" <sbourdette_at_danet.fr> wrote in message news:3c14cac6$0$3179$626a54ce_at_news.free.fr...
> How in PL SQL, can test if a table exists ?
>
> I try this
>
> IF EXISTS MyTable THEN
>
> END IF;
>
> But it doesn't work
>
> Thanks
>
>
Received on Mon Dec 10 2001 - 09:33:32 CST