Note
This view is available starting with V2.2.30.
Purpose
This view displays synonyms owned by the current user.
Applicability
This view is applicable only to 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 column is a column name only. A synonym can also be a synonym for other objects, such as views. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the object referenced by the synonym. |
| DB_LINK | VARCHAR2(128) | NO | If the synonym references a database link, this column specifies the name of the database 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
Query all synonyms in the current tenant: ALL_SYNONYMS
Query all synonyms in the current tenant: DBA_SYNONYMS
For more information about synonyms, see Manage synonyms.