really dumb oracle newbie question:

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