Monday, November 25, 2013

What is the difference between SYNONYM and ALIAS?

SYNONYM: is dropped when the table or table space is dropped Synonym is available only to the creator ALIAS: is retained even if table or table space 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.

0 comments:

Post a Comment