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

Home -> Community -> Usenet -> c.d.o.server -> Re: field deletion

Re: field deletion

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: 2000/06/06
Message-ID: <3lc%4.7398$9y3.32072@typhoon.tampabay.rr.com>#1/1

I don't remember which version this was introduced in (maybe 8.1.5?) but the syntax is:

alter table TABLE_NAME
drop column COLUMN_NAME
/

<christopher.lewis_at_ac.com> wrote in message news:8hj6ib$57e$1_at_nnrp1.deja.com...
> Hi all, what is the syntax for removing a field (and any constraints)
> from a table during an alter table? Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jun 06 2000 - 00:00:00 CDT

Original text of this message

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