Re: Removing a column from a table?

This is a very FAQ ! You can find solutions everywhere !

quick way is :

create temp_table as select <all_wanted_fields> from good_table;

then erase good_table and rename temp_table to good_table. There are packages that do this and I wonder if Oracle8i doesn't have this implemented... (although it is violating ANSI SQL compliance).

--
Jean-Christophe Boggio
cat_at_elma.fr
Independant consultant and developper
Linux, Delphi, Oracle, Perl