Re: SYNONYMS and view ALL_SYNONYMS

Martijn,

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'

Martijn Tonies wrote:
> Hi all,
>
> How do you know to what kind of item a particular synonym
> is "pointing"?
>
> All that the view ALL_SYNONYMS says is "table_name"
> as a column for the referenced object...
>
> --
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &
MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
Received on Thu Dec 30 2004 - 08:40:59 CST