Originally posted by aarroyob
You can't do that. The column name must be the same. You shall do:

1. Recreate the original table
2. Import this table
3. Create the new table
4. Do: insert into new_table(column1,column2 ...) select cloumn1,clomn2 ... from old_table
5. Drop the old table
6. Rename new_table to old_table

Hope that helps

Angel
Thanks guys!!

That is exactly what I though arroyob but I was told that you can change the column names as long as the datatypes are the same, I disgreed.

Basically we needed to add two columns and re-name some of the columns that had the name BLAH_BLAH_QTY
to BLAH_BLAH_QY to conform to business standards. I just found out that this was incorrect and that I will NOT have to re-name the columns, thanks god. All I need to do now is ALTER ADD, much easier.

Thanks again guys.

MH