| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete a column from a table?
In article <33240BD1.CDF_at_pmcgettigan.demon.co.uk>, Steve Phelan
<stevep_at_pmcgettigan.demon.co.uk> writes
>Connor McDonald wrote:
>>
>> Simon Goland wrote:
>> >
>> > Yes, I know, I have seen it here sometime ago. But it was "then", and I
>> > thought I won't need it... but now I do... ;-)
>> >
>> > So my long and tedious approach so far is:
>> >
>> > --
>> > [ Simon Goland B-)> sg_at_mda.ca ]
>> > [ Without action there is no change ]
>>
>> Cheap and easy way...but not really doing the drop...
>>
>> rename table xxx to xxx_gone
>> create view xxx as select (* minus missing column) from xxx_gone...
>>
>> Voila ! (Ugh...)
>>
>> Cheers
>> --
>> Connor McDonald
>> Systems Administrator-Unix/Oracle
>> BHP Iron Ore
>> "You're not drunk if you can lie on the floor without holding on"
>> - Dean Martin
>Shouldn't this read:
>
> rename table xxx to xxx_gone
> create table xxx as select (* minus missing column) from xxx_gone...
>
>That is, the second line should be creating a table, not a view on the
>old table you want to get rid of?
>
>Steve Phelan.
By creating a view he saves having to recreate the indexes, constraints, etc.
Andy Hardy. PGP key available on request
Computing power increases as the square of the cost. Received on Mon Mar 10 1997 - 00:00:00 CST
 |
 |