Skip to end of metadata
Go to start of metadata


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;

  • No labels