Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Removing a column from a table?
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 -------------------------------------------------------+Received on Tue Jun 13 2000 - 00:00:00 CDT
| email: kim_at_mpiz-koeln.mpg.de |
| WWW: http://www.mpiz-koeln.mpg.de/~kim/ |
*-----=< hierarchical systems are for files, not for humans >=-----*