Re: SYNONYMS and view ALL_SYNONYMS

Hello,

> You woul dneed to join the query to dba_objects or user_objects to find
> out the object_type.
>
> SQL> l
> 1 select s.table_name,s.table_owner,o.object_type,s.synonym_name
> 2 from dba_synonyms s,dba_objects o
> 3 where o.owner=s.table_owner
> 4 and o.object_name=s.table_name
> 5* and s.owner='PUBLIC'

Yeah, that's pretty much what I came up with as well... Thanks for the confirmation.

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com