I have a table which currently have 5 columns.
2 columns in the table are useless and hence I want to remove the 2 columns from the table.
I believe we do not have DROP COLUMN facility in DB2.
Hence for achieving this one option that I think about is copying the current table values into temporary table and then drop the old table and recreate it with required columns and copy the data from the temporary table to the new table.. But this seems to be a costly affair..
Could anyone suggest any other option or method to achieve this..