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
