From: "John Alexander" <jalexander@summitsoftwaredesign.com>
Subject: Re: field deletion
Date: 2000/06/06
Message-ID: <3lc%4.7398$9y3.32072@typhoon.tampabay.rr.com>#1/1
References: <8hj6ib$57e$1@nnrp1.deja.com>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.tampabay.rr.com 960319935 24.164.24.24 (Tue, 06 Jun 2000 15:32:15 EDT)
Organization: RoadRunner - TampaBay
X-MSMail-Priority: Normal
NNTP-Posting-Date: Tue, 06 Jun 2000 15:32:15 EDT
Newsgroups: comp.databases.oracle.server


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@ac.com> wrote in message
news:8hj6ib$57e$1@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.