Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
You have got it right.!. I would do
1. Unload the data into a file without that column. In the SQL query I would not give the column name that needs to be dropped. This way we dont need to reformat the data.
2. Drop the table and recreate it.
3. Load the data.