Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to drop a column????
Unfortunately, you can not drop a column from a table. Only way is to
rename it and create another table with
Create Table MyTable as Select col1, col2, col3 from RenamedTable;
And you have to create all the constraints, indexes, triggers etc.
Good luck.
Amar Duggasani
Paolo Quaglia <paolo_at_sitek.it> wrote in article
<01bd8a10$a027bab0$0b00a8c0_at_ntserver>...
> 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
>
Received on Wed Jun 03 1998 - 13:52:56 CDT