Purpose
The USER_SYNONYMS view displays all synonyms owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_SYNONYMS
DBA_SYNONYMS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SYNONYM_NAME | VARCHAR2(128) | NO | The name of the synonym. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the object referenced by the synonym. TABLE_OWNER is only a column name, and the synonym can be a synonym of any general object such as a view. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object referenced by the synonym. |
| DB_LINK | VARCHAR2(128) | NO | The name of the database link referenced. |