Re: How do you drop a column in Oracle 8?

In Oracle8 :
A table can be altered in really only two ways in regards to columns.

• You can change a column's definition.
• You can add a column(s) to an existing table.

The really only way, that I see, to accomplish getting rid of the column is really just to reorg it and leave out the column. You can also make a dump table, copy contents from the primary to the secondary and leave out the column. Then rebuild the table without the column and port the data back.

Keith D. Monton
monton_at_qni.com

P.S. - When you stated that this same sql worked for other databases are you referring to other types of databases ( Non-Oracle )?

Winnie Liu wrote in message <6us3na$qjj_at_sjx-ixn4.ix.netcom.com>...
>I never heard that Oracle can allow you to drop a column in the table just
>using alter table...!!
>
>Winnie
>
>ffinstad_at_globalsight.com wrote in message
><6ursht$hkv$1_at_nnrp1.dejanews.com>...
>>How do you drop a column in Oracle 8?
Received on Wed Sep 30 1998 - 22:25:47 CDT