From: HENEYA@ENTCF3XSPAM.agw.bt.co.uk (Alex Heney) Subject: Re: Dropping a column? Date: 1997/06/06 Message-ID: <339828fa.30086241@news.axion.bt.co.uk>#1/1 References: <33982628.73F78D85@srfs.pitt.edu> Organization: Not Very Newsgroups: comp.databases.oracle.misc On Fri, 06 Jun 1997 11:00:56 -0400, John Duska wrote: > >Is there some way to drop a column from a table? I know this sounds >stupid, but I can't find the command anywhere. >thanks >John > NO. You have to create a similar table, with tha column missing, copy the exiesting table into it, drop the existing table, recreate it with the column missing, and copy back from the temporary table. You then have to re-create any constraints and indexes on the original table. This is a real nuisance, to put it mildly. -- The above posting represents the personal opinions of the author and is not to be taken as official (or unofficial) policy or opinions of his employer. Remove XSPAM from mail_id if replying via email. Alex Heney, Living in the Global Village.