Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: really dumb oracle newbie question:
Ralf Sandner <r.sandner_at_system-design.com> wrote in article
<34335a2b.5826044_at_proxy>...
> hi...
>
> i feel like a complete dork: i just can't figure out the correct
> syntax to delete a column from an existing table...
>
> i tried
>
> ALTER TABLE -tablename-
> DROP (-columnname-);
>
> and after getting a "missing" keyword error
>
> ALTER TABLE -tablename-
> DROP COLUMN (-columnname-);
>
> but both did not work...
>
> there is no key or index on the column and there is no data stored
>
>
> --
> Ralf Sandner email: r.sandner_at_system-design.com
> System-Design GmbH rsandner_at_haitec.de
> Planstr. 25 www: http://www.system-design.com
> D-71229 Leonberg-Warmbronn Tel.: +49 07152 9764 786
>
You can't delete a column
Received on Mon Sep 29 1997 - 00:00:00 CDT