Re: ALTER TABLE DROP COLUMN ?
Date: 1996/02/02
Message-ID: <NEWTNews.823311898.27889.r_reuven_at_dialup.netvision.net.il>#1/1
In Article<4ei2pf$76j_at_maya.dei.unipd.it>, <qwerty_at_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_at_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_at_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_at_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
Received on Fri Feb 02 1996 - 00:00:00 CET