Re: Removing a column from a table?

Jean-Christophe Boggio <cat_at_creaweb.fr> wrote:
> 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).

Ok, I admit that this answers the question I posted, but unfortunately, it does not solve my problem. Unfortunately, there are quite a few foreign keys in other tables referencing the table in question.

So, to be more precise, I look for a way to get rid of a superfluous column which does not demand a temporary dissolution of referential integrity.

Sorry for having been imprecise before.

Greetinx, Jan

-- 
 +- Jan T. Kim -------------------------------------------------------+
 |             email: kim_at_mpiz-koeln.mpg.de                           |
 |             WWW:   http://www.mpiz-koeln.mpg.de/~kim/              |
 *-----=<  hierarchical systems are for files, not for humans  >=-----*