Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Getting rid of a column in a table

Getting rid of a column in a table

From: Brad huskins <bhuskins_at_christian-horizons.org>
Date: 2000/05/16
Message-ID: <39217409.E3CC19DD@christian-horizons.org>#1/1

Hello,

I am trying to drop a column from a table. I am logged in as SYSTEM, and can see the table. I am also able to add columns to it using ALTER TABLE table ADD ... .
However, when I try to use the ALTER TABLE table DROP (column) command, I get an error saying I'm 'missing a key word'. I looked this up in the docs, and I think I have the syntax right. Can anyone tell me what might be going wrong?

Thanks in advance.
/Brad. Received on Tue May 16 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US