USER_SYNONYMS v10

The USER_SYNONYMS view provides information about all synonyms owned by the current user.

NameTypeDescription
schema_nameTEXTThe name of the schema in which the synonym resides.
synonym_nameTEXTName of the synonym.
table_ownerTEXTUser name of the table’s owner on which the synonym is defined.
table_schema_nameTEXTThe name of the schema in which the table resides.
table_nameTEXTName of the table on which the synonym is defined.
db_linkTEXTName of any associated database link.