--On Freitag, Juni 10, 2005 21:20:33 +0200 ziga@mail.ljudmila.org wrote:
> Wouldn't
>
> ALTER [OBJECT] RENAME TO [schema.][name]
>
> be a better?
>
> After all, this is essentially a rename operation,
> so maybe it is better to extend existing syntax...
I don't think it's a good idea to merge two different semantics: Renaming a
table and "moving" a table to a different schema should be distinguished.
Furthermore, i think it's too error prone, because people could accidently
issue a "schema move" and renaming a table by a typo....
--
Bernd