At my work the DB2 gurus require us to drop/create a table in order to remove a column. Not sure if it's due to a technical or political reason. But in either case it's quite simple to do so. Of course you have unload the data before the drop and to reformat the data before loading. Claus