Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is the difference between SYNONYM and ALIAS?




266
views
asked mar August 3, 2014 05:07 AM  

What is the difference between SYNONYM and ALIAS?


           

1 Answers



 
answered By Mswami   0  

SYNONYM    : is dropped when the table or tablespace is dropped. Synonym is available only to the creator.

ALIAS          : is retained even if table or tablespace is dropped.  ALIAS can be created even if the table does not exist. It is used mainly in distributed environment to hide the location information from programs. Alias is a global object & is available to all.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert