This shouldn't be a problem....
Just tried it with a 4GB database, and everything seems fine here
(queries on the affected table were running smoothly)
Don't know how indizes on the affected columns could be affected,
though.
Other question:
Why don't you do this with simple ddl, as changing the domain of a
table's field is part of standard ddl? (ALTER TABLE table ALTER field
TYPE domain)

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Tuesday, July 10, 2001 8:55 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Direct modification to system tables to...
>
> > 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
>