--On Freitag, Juni 10, 2005 21:20:33 +0200 [EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to