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.