Обсуждение: Re: [GENERAL] Is it possible to change a columns name

>       alter table classname1 [*]
>            rename [column] attname1 to attname2


    It's good idea, but if I would change not the name, but properties for example :
create table pokus (col1 int, col2 varchar (20));

and now I would col1 as col1 int default 5 and col2 varchar (20) not null.
or col2 varchar (30)...

I search many MB of text about SQL etc., but I found only command for adding column or for the renaming it, but what
aboutremove some column or change properties of column? 

    Thanx for any ideas....

Pavel PaJaSoft Janousek
FoNet, spol. s r.o.

On Wed, 10 Mar 1999, Pavel PaJaSoft Janousek wrote:

> >       alter table classname1 [*]
> >            rename [column] attname1 to attname2
>
>
>     It's good idea, but if I would change not the name, but properties for example :
> create table pokus (col1 int, col2 varchar (20));
>
> and now I would col1 as col1 int default 5 and col2 varchar (20) not null.
> or col2 varchar (30)...
>
> I search many MB of text about SQL etc., but I found only command for
> adding column or for the renaming it, but what about remove some
> column or change properties of column?

I've run into this problem many times.. best answer I've found has been to
dump the database, recreate the table making any necessary changes, than
copy the data back in.










--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------