The ALL_SYNONYMS view provides the information on all synonyms that may be referenced by the current user.

Parameter Type Description
owner TEXT The username of the owner to which the synonym belongs.
schema_name TEXT The name of the schema to which the synonym belongs.
synonym_name TEXT The name of the synonym.
table_owner TEXT The username of the owner to which the object belongs.
table_schema_name TEXT The name of the schema to which the table belongs.
table_name TEXT The name of the object that the synonym refers to.
db_link TEXT The name of any associated database link.