Impact of dropping PUBLIC SYNONYM
Even if PUBLIC SYNONYM is all dropped, it does not affect the operation of the Altibase server.
How to drop PUBLIC SYNONYM
PUBLIC SYNONYM is created when a database is created to provide convenience to DB users, and it is not recommended to drop it because it uses general queries such as dual table lookup, or it is frequently used in procedures such as print and println.
However, if it needs to be dropped, the DROP statement can be used as follows.
Please drop it after checking whether PUBLIC SYNONYM is used in the application.
How to create PUBLIC SYNONYM
If a dropped PUBLIC SYNONYM is needed, create it as follows.