Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Removing a column from a table?

Removing a column from a table?

From: Jan Kim <kim_at_jupiter.mpiz-koeln.mpg.de>
Date: 2000/06/13
Message-ID: <8i6b47$fvb$1@gwdu67.gwdg.de>#1/1

Dear Oraclers,

is it possible to remove a column from a table? In other words, is there a command to undo the effect of

    ALTER TABLE mytable ADD superfluous_column INT;

As an alternative, is there a way to convince the ``imp'' program not to insist on creating the superfluous_column, even though it is in the dump file?

Greetinx & thanx in advance, 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 >=-----*
Received on Tue Jun 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US