synonym has to be re-created when object is dropped and re-created.

alias does not have to be re-created when object is dropped.

Hope this helps.

Victor
-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Friday, June 06, 2003 12:18 AM
To: [Email Address Removed] What is the difference between synonym and alias in DB2?






Hi DB2 DBAs,

Could someone tell me what is the difference between synonym and alias in
DB2?

Thanks
Sami


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] message is for the designated recipient only and may contain privileged
or confidential information. If you have received it in error, please
notify the sender immediately and delete the original. Any other use of the
E-Mail by you is prohibited.
****************************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page