Re^2: How to delete a column?

+++ jim.gregory # DaytonOH.attgis.com_at_2:240/5889 +++ "Re: How to delete a column?"

jg>
jg>  e.g.  create table b
jg>   <column list>
jg>          as select <columns > from table a;
jg>
jg> This will create your table ( less the column ) and load it from the old
jg> table.  Then drop table a and rename table b to table a.

But you'll be even more in trouble, if foreign key-constraints are engaged to keep your DB-design clean !

The VERY last solution is to save as much diskspace as possible and leave the column in the table :

1. update table a set col_to_delete = NULL; COMMIT;
2. alter table a modify ( col_to_delete varchar2(1));

And now, it nearly needs no more diskspace, while it's still existing.

Regards Karl

FIDO : 2:240/5840.3
MAIL : 100666.3450_at_compuserve.com Received on Mon Nov 20 1995 - 00:00:00 CET