Log in to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click
Management actions
The names of synonyms objects support ascending order by the head character by default in the synonyms list.
Shortcut function
The following functions are provided in the upper right corner of the tree:
| Action | Description |
|---|---|
| Create | Click this option to create synonyms. |
| Filter | Click this option to display valid/invalid synonyms. |
| Refresh | Click this option to refresh the structure tree after you perform management actions on the synonyms, so that the structure tree displays the latest information. |
Right-click function
Right-click the target object in the structure tree. A shortcut menu appears, displaying some management options provided by ODC for you to conveniently manage the target object.
The following table describes the management options.
| Option | Description |
|---|---|
| View Synonyms | Click this option to go to the synonyms management page, where you can view the basic information and codes of the synonyms. |
| Create Synonyms | Click this option to go to the
|
| Export | Export single table, see Export schemas and data. |
| Download | Download the SQL file for the synonyms object. |
| Delete | Click this option to delete the synonyms. |
| Refresh | Click this option to refresh the list after you perform management actions on the synonyms, so that the list displays the latest information. |
Synonym management page
Double-click the target synonym in the synonym list to go to the synonym management page, which provides the following two tabs:
Basic Info : displays synonym information such asName , **Object Owner ,Object Name ,Creation Time , andModified At .DDL : displays the script that defines the synonym. A synonym cannot be modified after it is created. You canDownload andFormat the synonym.