Unless you're working with Oracle V9, it's not possible to remove a column
from a table. You'll have to recreate it.
--
------------
Kind reGards
\ / |
X |
/ \ x
Gerard
Ralf Sandner <r.sandner_at_system-design.com> schreef in artikel
<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
>
Received on Mon Sep 29 1997 - 00:00:00 CDT
