interview

home / developersection / interviews / difference between alias and synonym in db2?

Difference between alias and synonym in db2?

Varun Agrawal 10025 28-Mar-2011

db2

Updated on 24-Sep-2020

Varun Agrawal

Other

Message

Can you answer this question?

2 Answers

27-Dec-2012

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.

28-Mar-2011

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

MindStick Training