January 28, 2014

A Follow-Up on Drop Column Support

When I recently wrote about the new DB2 11 drop column support, I admitted that I couldn't understand why this was such a highly requested feature. A commenter provided some insight.

The commenter -- Brian -- explained that the issue isn't (as I'd surmised) the random need to drop a column from a production table. More commonly, a developer may be asked to add a column, only to later learn it wasn't really needed. So now the developer must remove it.

In addition, Robert Catterall offers some good supporting information on adding and dropping columns. His post also examines some of the changes in DB2 11.

Have you had a chance to use drop column? If so please post some comments on the situation and how this has helped you.