I believe we do not have DROP COLUMN facility in DB2. I have 8 columns in my table.I need to drop 2 columns. Do we need to create new table with only 6 columns and drop the old table? If so, how to take care of the data what we already have in the table? Can anybody suggest me best approach to do so?
You need to do as your original post suggested. Create a new table without the 2 columns that are to be dropped. Populate the new table from the old table. Drop the old table. That appears to be the only way to do it.
The problem I have is that people can explain things quickly but I can only comprehend slowly. Regards Nic
did You look at the constraints listed in the link posted by Nic ?
cheers enrico When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser, so that I am sure that the information requested can be reached with a very small effort