> 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.