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. thanks, bryan
