What is an alias and how does it differ from a synonym?

An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
  • Interview Candidate
  • 4
  • 11475

Showing Answers 1 - 4 of 4 Answers

sithusithu

  • Jan 27th, 2006
 

An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.

Cheers,

Sithu

  Was this answer useful?  Yes

greeshmavarghese

  • Oct 7th, 2009
 

Sysnonym can be used for the user who created it. But alias can be used for any users. Synonym is dropped when base table got dropped but alias will not get dropped.  Synonym is recorded in the sys.synonym table and alias is recorded in sys.tables.

  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

 

Related Open Questions