add columns with ALTER TABLE, but put them not at the end?
I need to add some columns with an ALTER TABLE statement, but the default column order will put those columns at the end in a SQL browser. I'd rather put them in specific locations in the default column order. I can't do a DROP TABLE. I considered having an ALTER TABLE with a DROP clause including all of the existing columns, then an ADD clause including all the columns, including the new ones. However, wouldn't that result in a loss of data?