Re: How to delete column in a table ???

Macrino wrote:
>
> Can anyone help me how to delete unwanted column in a table ?

suppose you have table some_table with cols: col1, col2, col3, col4 and you want to remove col3 from it:

create table temp as select col1, col2, col4 from some_table; drop table some_table;
rename temp to some_table;

oracle 8.1 should have "alter table remove column ..." option too.

tanel. Received on Wed Jul 29 1998 - 01:55:50 CDT