Re: Removing columns from a table

From: Unknown <asavicki_at_sprint.ca>
Date: Thu, 17 Jun 1999 23:04:05 -0400
Message-ID: <zIia3.155892$r_1.31377558@newscontent-02.sprint.ca>

The only option I know is to re-create table without the unneeded column - here's how:

create table <your_table>_$$$ as
select field1, field2, ..., fieldn
from <your_table>;
-- list all columns except the one being removed drop table <your_table>;
rename <your_table>_$$$ <your_table>;

Could be a pain if you have 30+ columns in your table though...

HTH Alex

John Harris wrote in message <37697327.24698438_at_nurs.utah.edu>...
>Is it possible to remove tables from an oracle table? If so, how is it
>done? Thank you.
>
>John Harris
>University of Utah
>
Received on Thu Jun 17 1999 - 22:04:05 CDT