On Feb 19, 2008 1:25 PM, Bryan Pendleton <[EMAIL PROTECTED]> wrote: > > Is there a way to easily move a column from one table to another (as > > easy as a rename say)? > > alter table newtable add column newcolumn whatever-data-type; > update newtable set newcolumn = (value that the newcolumn should have); > alter table oldtable drop column oldcolumn; > > You'll also have to do some work to drop any constraints on > the old column from the old table, then add those constraints > to the new column in the new table once it's populated.
Can't all this be done automatically with a new move command? Amir > > thanks, > > bryan > > >
