Danesh Irani wrote:
Is "alter table drop column" part of the standard?
I know db2 dosent allow you to drop columns...DB2 Basic CLI 'Alter table'
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0000888.htm
DB2 'Alter table drop column' equals 'drops and re-creates the table'
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0011640.htm
Oracle has been able to do this for a while. When telling customers they
could do this (for the first time), I got cheers. The rules for drop
column are complex however. See:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_3001.htm#sthref3626
