DIFFERENCE BETWEEN ALIAS AND SYNONYM IN DB2?

Varun Agrawal

Total Post:159

Points:795
Posted by  Varun Agrawal
DB2 
DB2
 4070  View(s)
Ratings:
Rate this:
  1. Varun Agrawal

    Post:159

    Points:795
    Difference between alias and synonym in db2?

    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

  1. satish yedida

    Post:2

    Points:10
    Difference between alias and synonym in db2?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!