3.75 USER_SYNONYMS

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

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.