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 SYNONYM_NAME;

DROP PUBLIC SYNONYM PRINTLN;

How to create PUBLIC SYNONYM

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;