Re: How To: Determine if a Synonym Exists

Al Anderson wrote:

> Using SQL, does anyone know how to determine if a synonym exists?
>
> Thanks,
> Al Anderson

How about

SELECT synonym_name
FROM all_synonyms;

or

SELECT synonym_name
FROM dba_synonyms;

For you to not know the data dictionary views well enough to answer this question yourself should be a wake up call.

Immediately become friendly with the following SQL statement:

SELECT object_name
FROM all_objects
WHERE object_name LIKE '%whatyouaresearchingforhere%';

And substitute things like 'TAB' or 'SYN' or 'TRIG' for the text between the % signs.

Daniel Morgan Received on Wed Dec 11 2002 - 12:19:06 CST