On Thu, 9 Mar 2006, Jonah H. Harris wrote:
> 2) For my comprehension, what's the difference between a SYNONYM and a
>> single-object (possibly updatable) view?
>
> Not a whole lot actually. If we had updateable views, I'd suggest that
> people change their create synonym syntax to create view.
One key difference would be that synonyms track schema updates, like
adding a column, to the referenced object that a view would not.
Kris Jurka