Re: How to drop a column?

From: Mark G <mgumbs_at_hotmail.com>
Date: Mon, 4 Oct 1999 14:36:09 +0100
Message-ID: <37f8aaa3.0@145.227.194.253>

Apparently, it can be done in Oracle 8i. Otherwise, you have to save the old tables constraints, recreate a temp table without the offending column
(e.g create table emp2(empno, ename) as select empno, ename from emp)

Drop the old table and rename the temp table to what you want.

Mark

<wy_at_fudan.edu> wrote in message news:7t9h79$eo6$1_at_nnrp1.deja.com...
> Has oracle provide any ways to drop a column in a table?
> thanks in advance.
>
>
> YangWang.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 04 1999 - 08:36:09 CDT