Updated on 2024-06-03 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. The owner of the PUBLIC synonym is PUBLIC.

schema_name

text

Name of the schema to which the synonym belongs. The name of the schema to which the PUBLIC synonym belongs is NULL.

synonym_name

text

Synonym name.

table_owner

text

Owner of the associated object. Although the column is called table_owner, its associated object 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 the associated object. Although the column is called table_name, its 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 the associated object. Although the column is called table_schema_name, its associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.

db_link

character varying(128)

Reserved column. Its value is NULL.

origin_con_id

character varying(256)

Not supported. Its value is 0.