Re: How to delete a column?

Hi Rob,

it's not possible in the form of alter table drop column ...

You have to
create table <new_table> as select a, b, c from <your_table>; create index on new table ...

In article <47ntli$o8j_at_ritz.cec.wustl.edu>, rlc1_at_ritz.cec.wustl.edu (Robert L Carter) wrote:

> The title says it all...How do I delete a column??
> I can insert ... why can't I remove?
>
> -Rob
 

-- 
A. Dischner, AIX sysadmin, Oracle DBA           | Two planets meet;
Institut fuer Klinische Chemie                  | How are you ?
Klinikum Grosshadern                            | Bad ... , i 've got 
Ludwig Maximilians Universitaet Muenchen,  GER  | homo sapiens :-)
Marchioninistr.15 81366 Muenchen 49-89-70953202