Updated on 2023-10-23 GMT+08:00

DB_SYNONYMS

DB_SYNONYMS displays all synonyms accessible to the current user.

Table 1 DB_SYNONYMS columns

Name

Type

Description

owner

text

Owner of a synonym

schema_name

text

Name of the schema to which a synonym belongs

synonym_name

text

Name of a synonym

table_owner

text

Owner of an associated object Although the column is called table_owner, the associated object owned by the column is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.

table_name

text

Name of an associated object Although the column is called table_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.

table_schema_name

text

Schema name of an associated object Although the column is called table_schema_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.