Can we delete/remove columns from tables , if they were added using alter table command. we are using db2 7.1 on os/390.
Any help is appreciated.

Not possible with ALTER TABLE Statement...

Cheers
Sathayaram

No, you have to drop and recreate the table. I unload the data, drop and recreate the table and access rights, and load the data back, minus the deleted columns. You may invalidate all plans referencing that table (check for plans in SYSIBM.SYSPLANDEP), so rebinds may be needed. Triggers and views on that tables will be lost too. The Admin. Guide has a bit on the "Implications of dropping a table" that you might want to read before you do this, especially if the table is in production.

Hi,

"ALTER TABLE remove colums" will be available in DB2 v8.2 for LUW!

Hope this helps,
Grofaty

Won't help people with DB2 for z/OS and OS/390. They may be working on it, but no announcement that I know about.

My mistake, this alter table statement is just for LUW, not for z/OS.

Grofaty