Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DROP COLUMN Oracle 7.3
Here's a workaround:
Create a temporary table as a select statement of the current table without the column you want to drop. Then, drop the current table and rename the temporary table. Check out the Oracle SQL manual on 'subqueries' for exact syntax.
For example, dropping col4 from my_table:
create table temp_table(col1,col2,col3,col5) as select col1,col2,col3,col5 from my_table;
cheers
Mark Poticha wrote:
>
> I will drop a column 'COL1' in the Table 'DEMO.TEST', but I can not find
> something like
>
> ALTER TABLE DEMO.TEST DROP COLUMN COL1
>
> Any Ideas?
>
> Thanks very much.
>
> Mark Poticha
>
> poticha_at_rbg.informatik.tu-darmstadt.de
--
Jeffery Cann
Fairway Systems, Inc.
Senior Software Engineer
Received on Wed Jun 24 1998 - 16:41:46 CDT