Re: Drop column from a table

SKurosky wrote in <20000117230335.27539.00001006_at_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?

nope - drop column is not a language feature

>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...

i'd suggest :
rename temp to original;

regards Received on Mon Jan 24 2000 - 22:44:14 CST