Re: [Q] How do I drop a column from a table?
From: <arahman_at_mja.net>
Date: 1996/12/09
Message-ID: <58hbje$o9d9_at_news.knox.edu>#1/1
>I am trying to drop a column from a table. I thought that I could use
>the ALTER TABLE command, but I can't seem to get it to work. I am
>using "Oracle: The Complete Reference" by Koch and Loney. It has lots
>of stuff on adding and modifying columns, but not one word on deleting
>or dropping them.
Date: 1996/12/09
Message-ID: <58hbje$o9d9_at_news.knox.edu>#1/1
logicprobe_at_bbs.kis.net (Steve Crowe) wrote: Sorry friend..Droping a column using ALTER...... You have to recreate a new table and then move the necessary date to
new table.....then drop the old table................arahman_at_mja.net
>I am trying to drop a column from a table. I thought that I could use
>the ALTER TABLE command, but I can't seem to get it to work. I am
>using "Oracle: The Complete Reference" by Koch and Loney. It has lots
>of stuff on adding and modifying columns, but not one word on deleting
>or dropping them.
>Any help would be most welcome,
>Steve Crowe
>logicprobe_at_bbs.kis.net
Received on Mon Dec 09 1996 - 00:00:00 CET