Re: How to drop a column????

From: <jtesta_at_my-dejanews.com>
Date: Mon, 01 Jun 1998 13:18:47 GMT
Message-ID: <6ku9nm$r9q$1@nnrp1.dejanews.com>

Oracle does not support that option, yet(version 8.1.X it will). in the mean time, you can get my drop column package from my web site, it will re-create the table with all the constraints, etc, leaving out the column u dont want. source code for it is there also.

joe
http://www.oracle-dba.com

look under the oracle scripts link

In article <01bd8a10$a027bab0$0b00a8c0_at_ntserver>, "Paolo Quaglia" <paolo_at_sitek.it> wrote:
>
> Hi I'm a new user of ORACLE 8 .
> I came from other DB server expaerience.
> In SQL to drop a column from a table I used
>
> ALTER TABLE name_table DROP COLUMN name_of_ column;
>
> In ORACLE SQL this expression is not recognized
> I have read the SQL manual but I have not found the solution
>
> HELP me
> Ciao
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 08:18:47 CDT