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
Liked By
Write Answer
Difference between alias and synonym in db2?
Join MindStick Community
You have need login or register for voting of answers or question.
satish yedida
27-Dec-2012Alias : 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.
Varun Agrawal
28-Mar-2011Reply With Quote