Re: Existence of tables - checking

just do
select 0 from table1;
and see the results... :)

Preetha Suri wrote:

> Hello,
>
> Consider the following scenario:
> user1 has a synonym to table1 which exists in user2.
>
> From user1, I have to check if table1 actually exists in user2.
> Would anybody be able to help me with an SQL statement for this??
>
> Thanks in advance.
>
> Regards,
> Preetha.
Received on Sat Mar 31 2001 - 08:50:31 CST