On 3/9/06,
Josh Berkus <
josh@agliodbs.com> wrote:
1) Is there a SQL standard for this?
Nope.
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. However, it would take substantially more work to implement updatable views than synonyms and the functionality of updatable views is substantially different than the use of synonyms alone. If/when updatable views are implemented, I wouldn't have a problem switching create synonym to actually create a view.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324