Note
This view is available starting with V2.2.30.
Purpose
Queries the synonyms owned by the current user.
Applicability
This view is available starting with OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SYNONYM_NAME | VARCHAR2(128) | NO | The name of the synonym. |
| TABLE_OWNER | VARCHAR2(128) | NO | The name of the object referenced by the synonym. The TABLE_NAME here is just a column name. A synonym can also refer to other objects, such as views. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object referenced by the synonym. |
| DB_LINK | VARCHAR2(128) | NO | The name of the DB link if the synonym refers to a DB link. |
Sample query
Query all synonyms owned by the current user.
obclient [SYS]> SELECT * FROM SYS.USER_SYNONYMS;
The query result is as follows:
+--------------+-------------+------------+---------+---------------+
| SYNONYM_NAME | TABLE_OWNER | TABLE_NAME | DB_LINK | ORIGIN_CON_ID |
+--------------+-------------+------------+---------+---------------+
| S1 | SYS | TEST | NULL | 0 |
+--------------+-------------+------------+---------+---------------+
1 row in set
References
ALL_SYNONYMS: queries all synonyms in the current tenant.
DBA_SYNONYMS: queries all synonyms in the current tenant.
For more information about synonyms, see Manage synonyms.