Il gio, 2003-11-06 alle 16:00, scott.marlowe ha scritto:
> > I need, also, to move columns in tables (just like the MOVE BEFORE/MOVE
> > AFTER MySQL commands). Can you help me?
>
> I do it with select into:
>
> begin;
> select field3, field2, field4, field1 into newtable from oldtable;
> drop oldtable;
> alter table newtable rename to oldtable;
> commit; (or rollback; if something goes wrong).
Good idea! But you'll lose CONSTRAINTs and DEFAULTs. Isn't it?
Cheers,
Marco