Re: Drop column from a table

From: SKurosky <skurosky_at_aol.com>
Date: 18 Jan 2000 04:03:35 GMT
Message-ID: <20000117230335.27539.00001006@ng-fz1.aol.com>

>I'm using Oracle 7.3.4 and have decided to move two columns from one
>table to another table. I would have thought I could just do an ALTER
>command but that doesn't seem to work and I cannot find any example
>for check my syntax. Here's the statement:
>
>alter table T drop column C
>
>I also tried without teh "column" bit but got the same results.
>
>Can I drop a column from table?
>
>JMH
>
>
>
>
>
>

Create a temp table with only the columns you want.. Create table temp as

                select ....

drop the original table, then recreate with the create table as select... HtH
Sandy Received on Mon Jan 17 2000 - 22:03:35 CST