What is a synonym? How is it used?

A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities when the code is migrated. The synonym is linked to the AUTHID that created it.
  • Interview Candidate
  • 3
  • 8653

Showing Answers 1 - 3 of 3 Answers

Raghuram Balakrishnan

  • Jul 19th, 2007
 

Also, a Synonym is specific to the DB2 subsystem.  Synonym can only access the table or view in the subsystem in which it is defined.   A synonym is dropped when the table is dropped.

An Alias is yet another name for a table or view. But it can refer to DB2 tables in other Db2 subsytems which are connected to each other.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions