Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Removing a column from a table?
if you are using 8.1.6 then you can.
I am not user about the syntax(alter table tbal remove column xxxx).
for other versions well you know what to do.
Tom
Jan Kim <kim_at_jupiter.mpiz-koeln.mpg.de> wrote in message
news:8i6b47$fvb$1_at_gwdu67.gwdg.de...
> 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 Wed Jun 14 2000 - 00:00:00 CDT