Re: Alter table

Uz.ytkownik Rachel.Vaudron napisa?:
> Hi,
> 
> I wonder if it is possible to remove a field of a table ?
> I haven't found anything about this into the reference manual.
> Can I do something like that ?:
> 
> ALTER TABLE table
> DROP COLUMN column;
alter table xxx rename to temp;
create table xxx as select field1, field2, ...without some field... from temp;
drop table temp;

Tomasz Myrta