Updated on 2024-05-13 GMT+08:00

ALL_SYNONYMS

ALL_SYNONYMS displays all synonyms accessible to the current user.

Table 1 ALL_SYNONYMS columns

Name

Type

Description

owner

text

Owner of a synonym.

schema_name

text

Name of the schema to which the synonym belongs

synonym_name

text

Synonym name

table_owner

text

Owner of the associated object

table_schema_name

text

Schema name of the associated object

table_name

text

Name of the associated object