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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend