This is my blog on Java and related technologies and tools that I have worked on. I started this blog just to keep my Java knowledge updated which can also be a place for quick reference. The source of most of the articles are a mixture of my views and the place where i read it. Comments are most welcome and please rectify me wherever i have gone wrong.
Thursday, November 4, 2010
Difference between Alias and 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. 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment