Xref: alice comp.databases.oracle.misc:17256
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!ix.netcom.com!news
From: "Winnie Liu" <poohland@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Drop Field
Date: Tue, 7 Jul 1998 20:21:07 -0700
Organization: ICGNetcom
Lines: 35
Message-ID: <6nuob9$bpc@sjx-ixn6.ix.netcom.com>
References: <359F2729.63FAE2E@trec.ce.gatech.edu> <01bda89f$5c554340$4b6ea1bf@pc2596.DDNS>
X-NETCOM-Date: Tue Jul 07  8:16:57 PM PDT 1998
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Try to create a new table as selecting part of the columns from the old
table:

CREATE TABLE <NEW TABLE> AS SELECT <COLA, COLB, .. COLN> FROM <OLD TABLE>
If you want the new table to have the same name as the old table, then
rename your old table first and then use that name to create the new table.

RENAME <OLD TABLENAME> TO <NEW TABLENAME>;

Then you can create another table with one (or a few less field).

Or you should consider creating a view by selecting only some of the columns
from the tables.

Winnie Liu
DBA
Unihealth,CA



Bruger wrote in message <01bda89f$5c554340$4b6ea1bf@pc2596.DDNS>...
>Hi
>You canīt drop a field name !!! You have to drop and recreate the whole
>table...
>
>Arif Mohammed <arif@trec.ce.gatech.edu> skrev i artiklen
><359F2729.63FAE2E@trec.ce.gatech.edu>...
>> Does anyone know how to drop a field from an existing table in Sql.
>> I tried Alter - Alter table <table-name> drop <field-name>, but gives
>> error saying missing keyword at the field-name.
>>
>>
>>