Home -> Usenet -> comp.databases.oracle -> Removing a Column

Removing a Column

From: Bill Jonnard <bjonnard_at_ix.netcom.com>
Date: 1996/08/20
Message-ID: <4vbi2b$73s_at_sjx-ixn2.ix.netcom.com>#1/1 







This question has been bugging me for the last few years:



Is there any way to remove a column from a table other than to
recreate the table (minus the offending column) and then inserting all
the rows into the new table?



I am attempting to remove a number of obsolete columns from a very
large table, and the prospect of having to solve this problem in the
manner described above almost makes it a pointless exercise due to the
amount of time, resources, etc that it would take.



Thanks for any advice.  -- Bill    bjonnard_at_ix.netcom.com
Received on Tue Aug 20 1996 - 00:00:00 CEST












Original text of this message