The USER_SYNONYMS view provides the information about all synonyms owned by the current
user.
Parameter | Type | Description |
Parameter |
Type |
Description |
schema_name |
TEXT |
The name of the schema to which the synonym belongs. |
synonym_name |
TEXT |
The name of the synonym. |
table_owner |
TEXT |
The username of the owner of the table on which the synonym is defined. |
table_schema_name |
TEXT |
The name of the schema to which the table belongs. |
table_name |
TEXT |
The name of the table on which the synonym is defined. |
db_link |
TEXT |
The name of any associated database link. |