USER_SYNONYMS v16

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

NameTypeDescription
schema_nameTEXTName of the schema in which the synonym resides.
synonym_nameTEXTName of the synonym.
table_ownerTEXTUser name of the owner of the table on which the synonym is defined.
table_schema_nameTEXTName 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.