Re: Existence of tables - checking

maybe you want to do something like this: Select table1 from all_user_tables where user_id = "user2"

if this returns a row then table1 exists otherwise not. (please correct the columns since i cannot look onto Oracle right now)

Martin

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 Wed Mar 28 2001 - 05:44:42 CST