Re: dropping table column

In <8044.2cb05683_at_hayes.com> fgreene_at_hayes.com writes:
>correct. The only way to do it is to drop the entire t able and then recreate
>it using the correct column definitions. If you have to retain the data
>you must make sure to save it as well.

Another way to do this is to create a temporary table with the columns that are needed. E.g. if you have: Table_1 (Col_1, Col_2, Col_3, Col_4) and you want to drop column Col_3, create table Table_2 :

   SQL> create table Table_2 as select Col_1, Col_2, Col_4 from Table_1;

The columns in Table_2 will be named the same as in Table_1. Drop table Table_1 and create NEW Table_1 :

   SQL> drop table Table_1
   SQL> create table Table_1 as select * from Table_2;
   SQL> drop table Table_2;

Now you have Table_1 with the columns you wanted.

-- 
-----------------------------------------------------------------
Olli Heinamaki, Computing Center, University of Helsinki, Finland
Mail : Olli.Heinamaki_at_Helsinki.FI   Tel.: + 358-0-708-4645 (work)
       heinamaki_at_finuh.bitnet             + 358-0-345-3580 (home)