>> 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.
Yes, I do this always too, but I prefer SQL syntax before manual editing dumped database....
Have somebody any idea?
Pavel PaJaSoft Janousek
FoNet, spol. s r.o.