Even if PUBLIC SYNONYM is all dropped, it does not affect the operation of the Altibase server.
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.
DROP PUBLIC SYNONYM SYNONYM_NAME;
DROP PUBLIC SYNONYM PRINTLN;
If a dropped PUBLIC SYNONYM is needed, create it as follows.
CREATE PUBLIC SYNONYM SYNONYM_NAME FOR SYSTEM_.OBJECT_NAME;
CREATE PUBLIC SYNONYM PRINTLN FOR SYSTEM_.PRINTLN;