Jun 7, 2005 #1 SowKan Technical User Mar 18, 2004 24 IN Is there a direct command to delete a column from a table? Thx in advance, Sowmya.
Jun 7, 2005 #2 Mercury2 Technical User Feb 27, 2004 422 FR ALTER TABLE MyTable DROP COLUMN MyColumn ... Upvote 0 Downvote
Jun 7, 2005 #3 rbod Programmer Feb 1, 2005 74 US DB2 does not support dropping columns. Upvote 0 Downvote
Jun 7, 2005 #4 MarcLodge Programmer Feb 26, 2002 1,886 GB I am under the impression that DB2 does not have the function you require, although I have read somewhere that DB2 for iSeries does. The way I have seen this performed is to create a new table and INSERT with a subselect from the original. Hope this helps Marc Upvote 0 Downvote
I am under the impression that DB2 does not have the function you require, although I have read somewhere that DB2 for iSeries does. The way I have seen this performed is to create a new table and INSERT with a subselect from the original. Hope this helps Marc