> 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?
Thanx for any ideas....
Pavel PaJaSoft Janousek
FoNet, spol. s r.o.