Re: How to delete column in a table ???

Tanel Põder wrote:
>
> Macrino wrote:
> >
> > Can anyone help me how to delete unwanted column in a table ?
>
> suppose you have table some_table with cols: col1, col2, col3, col4
> and you want to remove col3 from it:
>
> create table temp as select col1, col2, col4 from some_table;
> drop table some_table;
> rename temp to some_table;
>

In this case you must be careful with existing constraints on changed table

--

With best regards,
Igor Kirasirov

                    --oOo--

   Igor Kirasirov            mailto:kir_at_aix.krid.crimea.ua       
 Simferopol, Crimea          voice : work  +38-0652-521-032
     Ukraine                         home  +38-0652-275-956