Difference between alias and synonym in db2?

Question

satish yedida · Answer

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.

Varun Agrawal · Answer

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

interview

Difference between alias and synonym in db2?

Can you answer this question?

2 Answers