Home > DeveloperSection > Interviews > Difference between alias and synonym in db2?

Posted on    March-28-2011 5:42 AM

 DB2 DB2 
 2 Answer(s)
  3815  View(s)
Rate this:

Varun Agrawal
Varun Agrawal

Total Post:159

Posted on    March-28-2011 12:00 AM

An alias is typically used to point a table, view or alias in a different DB2 subsystem. The existance of the object will NOT be verified at the time of alias creation but will produce a warning if referenced and doesn't exist on the local subsystem. A synonym is created as another name for a table or view.
Reply With Quote

satish yedida
satish yedida

Total Post:2

Posted on    December-27-2012 1:00 AM

Alias : A locally defined name for a table given by user. If the table has dropped, your alias is present.

Synonym : An alernative , private name for a table , defined by owner. If the table has dropped , the synonym defined on that table also dropped.

Don't want to miss updates? Please click the below button!

Follow MindStick