Re: Alter Column Position

Derrick Betts wrote:
> I have a table with 10,000 rows.  We have an application that parses a *.csv
> file and uploads the data to the database table.  The csv parser takes the
> column numbers form the csv file and matches the column numbers to the field
> positions in the DB table.
>
> Now, I have to change the position of a column in the DB to match the csv
> parser.  I have a column in position 28 that I need to move to position 7.
>
> Anyone know how to do that?

You could DROP and re-CREATE the table.

CREATE TABLE tmp AS SELECT col1, col3, col2 FROM mytab;
DROP TABLE mytab;
ALTER TABLE tmp RENAME TO mytab;

_BUT_: You need to take care of special cases like UNIQUE & FOREIGN KEYs
etc., i.e. usually you need a better CREATE clause than this easy example.


> Thanks,
> Derrick

HTH
--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de