Log on to OceanBase Developer Center (ODC) and click the name of the target connection to go to the corresponding connection management page. You can click Synonym in the left-side navigation pane to get a list of synonyms or a list of public synonyms. To create a synonym, click + in the upper-right corner of the synonym list or click Create in the navigation bar on the top of the page.
Click Create . In the Create Synonym dialog box, specify the following information:
Synonym Name : specifies the name of the synonym. The name cannot be empty and must be less than 128 characters in length.
Object Owner : specifies the schema to which the synonym belongs. Select the schema from the drop-down list. This parameter must be specified.
Object Type : specifies the type of the object that the synonym represents. Select the type from the drop-down list. You can create a synonym for a TABLE object or a VIEW object. This parameter must be specified.
Object Name : specifies the object that the synonym represents. This parameter must be specified.
Synonym Type : specifies the type of the synonym. Supported types: Synonym and Public Synonym . This parameter must be specified.
After you specify the information, click Next: Verify SQL Statement to go to the statement editing page, where a synonym definition statement is generated based on the information specified in the Create Synonym dialog box. You can modify this statement. After you confirm the statement, click the Create button in the upper-right corner of the page to complete the creation. A synonym cannot be modified after it is created.
In addition, the toolbar on the editing page provides the following buttons:
| Button | Description |
|---|---|
| Format | Click this button to apply formatting, such as indentation, line break, and keyword highlighting, to the selected SQL statements or all the SQL statements in the current SQL window. |
| Find and Replace | You can specify search criteria in the search box to find specific content in the script and enter other content in the replacement box to replace the content found. |
| Undo | Click this button to undo the last operation. |
| Redo | Click this button to reverse an Undo operation. |
| Case Sensitivity | The system supports three configurations: All Caps , All Lowercase , and Capitalize the first letter . Click this button to convert the selected statements in the script to the corresponding capitalization format. |
| Indent | The Add Indents and Delete Indent options are provided, to allow you to add indents to or delete indents from the selected statements in the script. |
| Comment | The Add Comments and Delete Comment options are provided, which respectively allow you to convert the selected statements in the script to comments and convert comments to SQL statements. |