Re: Delete an column from a table

Bear in mind that you will lose any integrity constraints from the original table!

Mark

Martin wrote in message <3738735d.20889157_at_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 Wed May 12 1999 - 03:12:01 CDT