Hi Alexandre,

> I cannot change the mandatory status of a field
> (specialy from Not Null to Nulls allowed) using
> metadata updates (IBexpert in fact).
>
> It seems to work, tough, in the other way. I can
> change a column that allowed nulls to not null, but
> once done that, can't make it back.
>
> The only way left, of course, is to recreate the
> table. I wonder if this could be a bug or am I missing
> something?

Changing from NULL -> NOT NULL or back is
done via a system table update.

Exactly why can't you do this? Do you get an
error of some sort?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com