From: r_reuven@netvision.net.il
Subject: Re: ALTER TABLE DROP COLUMN ?
Date: 1996/02/02
Message-ID: <NEWTNews.823311898.27889.r_reuven@dialup.netvision.net.il>#1/1
references: <4ei2pf$76j@maya.dei.unipd.it>
content-type: TEXT/PLAIN; charset=US-ASCII
organization: NetVision LTD.
mime-version: 1.0
newsgroups: comp.databases.oracle



In Article<4ei2pf$76j@maya.dei.unipd.it>, <qwerty@chiara.dei.unipd.it> write:
> Path: 
news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.i
nternetmci.com!chi-news.cic.net!usc!math.ohio-state.edu!jussieu.fr!univ-lyon1.f
r!dsi.unimi.it!maya.dei.unipd.it!qwerty
> From: qwerty@chiara.dei.unipd.it (Luigi Scappin 264462/IL)
> Newsgroups: comp.databases.oracle
> Subject: ALTER TABLE DROP COLUMN ?
> Date: 29 Jan 1996 09:07:59 GMT
> Organization: D.E.I - Universita' di Padova, Italia
> Lines: 9
> Message-ID: <4ei2pf$76j@maya.dei.unipd.it>
> NNTP-Posting-Host: chiara.dei.unipd.it
> 
> Hi.
> I'm loking for an Oracle SQL statement to DROP a COLUMN in a database table.
> I think it's a stupid question... but I don't know how... :-)
> Thank's in advance.
> 
> 	Luigi Scappin
> 
> 	qwerty@lead.it
> 
you cannot drop a column create a duplicate table whitout the column then
insert from the old table to the newone then drop old table and rename new 
table to the old table name