Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.30 DBA_SYNONYMS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.30 DBA_SYNONYMS

The DBA_SYNONYM view provides information about all synonyms in the database.

Name

Type

Description

owner

VARCHAR2

User name of the synonym’s owner.

schema_name

TEXT

Name of the schema in which the synonym belongs.

synonym_name

VARCHAR2

Name of the synonym.

table_owner

VARCHAR2

User name of the table’s owner on which the synonym is defined.

table_name

VARCHAR2

Name of the table on which the synonym is defined.

db_link

VARCHAR2

Name of any associated database link.

Previous PageTable Of ContentsNext Page