Re: How to drop a column of a table?

From: Remco Blaakmeer <remco_at_rd31-144.quicknet.nl>
Date: 3 Mar 1999 22:50:29 GMT
Message-ID: <7bkebl$kkn$1@rd31-144.quicknet.nl>

In article <01be65bc$298a0240$38434cc0_at_txu>,

"Tony Xu" <tonyxu89_at_yahoo.com> writes:
> Is there a way to alter a table and drop one column of the table? Thanks,

No, this is not possible. The only way to do what you want is to drop and recreate the table. You could temporarily store the data in another table using a 'insert into ... select ...' statement, if you have enough free space left.

Alternatively, you could fill the entire column with NULL values and then make it a small column, like varchar2(1) or so.

Remco
--
rd31-144: 11:20pm up 3 days, 5:10, 3 users, load average: 1.00, 1.00, 1.03 Received on Wed Mar 03 1999 - 16:50:29 CST