A synonym is an alias for a database object. Synonyms are often used to simplify object access and improve security. Similar to a view, a synonym does not use actual storage space. Only its definition is stored in the data dictionary. There are two types of synonyms: public and private.
In OceanBase Developer Center (ODC), click a connection name to open the connection. In the navigation pane on the left, click the Synonyms tab to view the list of synonyms. To create a synonym, click the + button in the upper-right corner of the list. To manage a synonym, double-click its name in the list to open the management page. On the management page, you can view the basic information and code of the synonym.
The database version requirements are as follows:
Database | Version |
OceanBase database Oracle mode | V2.2.0 and later. |
OceanBase database MySQL mode | V2.2.0 and later. |
This chapter describes the following operations on synonym objects in ODC: