what is sql code to delete column ?

[ballaravi]

what is sql code to delete column in db2?

[NicC]

I am not sure if you can delete a column unless it has come in in recent versions of DB2. The normal way is to drop the table and recreate it with the new definition.

[dick scherrer]

Hello,

There are often problems with terminology - what does "delete a column" mean to you?

[ballaravi]

just consider in an EMP table i have columns (empno,empname,salary,deptno).
now i dont what to deptno on the EMP table, how to delete that column.

[NicC]

1) unload the data from the current table but ignore the data in the column that you do not want
2) drop the table
3) recreat the table with the new definition
4) load the table from the saved data

[ballaravi]

ok,good idea only, but in sql server and oracle we can delete the column direcly, need of above septs, why it is not in db2. thats why i asked.if we have more data it is difficcult one..

ok thank you... for ur answer..