Jun 7, 2005 #1 SowKan Technical User Joined Mar 18, 2004 Messages 24 Location IN Is there a direct command to delete a column from a table? Thx in advance, Sowmya.
Jun 7, 2005 #2 Mercury2 Technical User Joined Feb 27, 2004 Messages 422 Location FR ALTER TABLE MyTable DROP COLUMN MyColumn ... Upvote 0 Downvote
Jun 7, 2005 #3 rbod Programmer Joined Feb 1, 2005 Messages 74 Location US DB2 does not support dropping columns. Upvote 0 Downvote
Jun 7, 2005 #4 MarcLodge Programmer Joined Feb 26, 2002 Messages 1,886 Location 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