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
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