Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete an column from a table

Re: Delete an column from a table

From: Martin <a9426017_at_remove.unet.univie.ac.at>
Date: Tue, 11 May 1999 18:13:07 GMT
Message-ID: <3738735d.20889157@news.telekabel.at>


Thanks, I anticipated it.
Martin

On Tue, 11 May 1999 18:55:42 +0200, "Kurt Laugesen" <kul_at_post3.tele.dk> wrote:

>No - it is not possible.
>
>The only way is to create a new table as select all (minus the one column)
>from the old table, delete the old table and rename the new one.
>
>Regards
>Kurt Laugesen
>kurtL_at_corebit.dk
>
>Martin wrote in message <373831d6.4113895_at_news.telekabel.at>...
>>Is it possible to delete one colomn from a existing table under Oracle
>>7.4.3 within Sqlplus?
>>I donīt want to delete the whole table.
>>
>>Martin
>>
>
Received on Tue May 11 1999 - 13:13:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US