I only want to drop a column of a table with RC/Update alteration or a RC/Migrator strategy.
However, a DROP TABLE is generated instead of ALTER TABLE .. DROP COLUMN ...
Please make sure there are no DB2 restrictions for dropping the column, e.g. if the containing table space is not a universal table space.
See a complete list here:
(search for ‘A column cannot be dropped if any of the following conditions are true’)
ALTER TABLE DROP COLUMN Support
Was this information helpful?