Re: Drop column help

Hi Jane,

You can do this with create table command. Here is how you can remove that column.

create table b as select col1,col2,... from table a ;

where table a is your original table and in the select statement don't include the column that you want to drop. After the new table is created drop the orginal one.

To play safe, I would backup the original table before doing this.

good luck !!

Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article <33A5AC39.FCF0B165_at_hnrc.tufts.edu>...
> I'm using Oracle 7.3 WGS on NT 4.0.
> Is it possible to drop a column from a table ? SQL does not have this
> clause through ALTER TABLE command. However, in the Enterprise Manager
> there is a button that "allow to remove a column from a list" (according
> to the on-line help). That either did not work for me, the button gets
> unable all the time.
>
> Any inputs are very welcome,
>
> Jane
>
>
>
Received on Wed Jun 25 1997 - 00:00:00 CDT