IBM Mainframe Forum

Hi,

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?

It may depend on your level of DB2. I found this article when Googling:
http://ibmsystemsmag.com/Blogs/db2utor/Archive/drop-column-support/

Hi Nic,

Thanks for the reply.
But, I have 10.1 version.

Thanks,
Shankar.

Hi Forum,

Any more suggestions for my post??

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.

Hi,
please check this if it works

ALTER TABLE <table.name> DROP COLUMN <column.name>.

please check this if it works

did You look at the constraints listed in the link posted by Nic ?

Ya.. i,m sorry.,we can do by the way as Nic said..