1.

What Is The Difference Between Synonym And Alias?

Answer»

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 info from PROGRAMS. Alias is a global object & is available to all.

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 info from programs. Alias is a global object & is available to all.


Discussion

No Comment Found

Related InterviewSolutions