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.
DROP PUBLIC SYNONYM statement
DROP PUBLIC SYNONYM SYNONYM_NAME;
Example of dropping PRINTLN
DROP PUBLIC SYNONYM PRINTLN;
How to create PUBLIC SYNONYM
If a dropped PUBLIC SYNONYM is needed, create it as follows.
CREATE PUBLIC SYNONYM statement
CREATE PUBLIC SYNONYM SYNONYM_NAME FOR SYSTEM_.OBJECT_NAME;
Example of creating PRINTLN
CREATE PUBLIC SYNONYM PRINTLN FOR SYSTEM_.PRINTLN;