3.75 USER_SYNONYMS

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

3 Oracle Catalog Views : 3.75 USER_SYNONYMS

3.75 USER_SYNONYMS

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

Name

Type

Description

schema_name

TEXT

The name of the schema in which the synonym resides.

synonym_name

TEXT

Name of the synonym.

table_owner

TEXT

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

table_schema_name

TEXT

The name of the schema in which the table resides.

table_name

TEXT

Name of the table on which the synonym is defined.

db_link

TEXT

Name of any associated database link.

3 Oracle Catalog Views : 3.75 USER_SYNONYMS

Name	Type	Description
schema_name	TEXT	The name of the schema in which the synonym resides.
synonym_name	TEXT	Name of the synonym.
table_owner	TEXT	User name of the table’s owner on which the synonym is defined.
table_schema_name	TEXT	The name of the schema in which the table resides.
table_name	TEXT	Name of the table on which the synonym is defined.
db_link	TEXT	Name of any associated database link.