> most of the IB administration Systems do it right this way:
>
> update RDB$FIELDS set
> RDB$FIELD_TYPE = xx
> where RDB$FIELD_NAME = xx
>
> I never experienced any problem with this....

Nor have I but in my case I am doing this:

UPDATE RDB$RELATION_FIELDS
SET RDB$FIELD_SOURCE = xx
WHERE ...

This takes a column and changes it from one domain to another domain.
I cannot change the type of the domain because other columns defined with it
need to remain as they are.

Thanks for any additional comments.

PS. It does seem to be working without any fireworks.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com