Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How do you drop a column in Oracle 8?
How do you drop a column in Oracle 8?
I'm using the sql call:
ALTER TABLE mytable DROP mycolumn;
I get the error message:
ORA-00905: missing keyword before mycolumn.
Any ideas? This same sql worked in for me in other databases.
Any help is appreciated.
Thanks
--
Franco Finstad
Web Developer
Global Sight Corp.
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 29 1998 - 19:04:13 CDT