Re: Renaming a column

This idea is not bad, Then you can drop the old table and rename the new to the old name.
But you still have to recreate every trigger, indexes and recompile views and funtions etc.
Regards
Nicolas Bronke
ashesh48_at_my-dejanews.com schrieb in Nachricht <702ot0$p7f$1_at_nnrp1.dejanews.com>...
>Or may be u can try something like this....
>
>create table A as select old_name new_name ,col1,col2,,,,, from table ;
>
Received on Thu Oct 15 1998 - 04:10:51 CDT