Subject Re: [ib-support] Direct modification to system tables to...
Author Jason Wharton
Nick,

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

I'm working with a legacy database on IB 5.6.
It is always a good idea to clear away constraints and indexes whenever
tinkering with system relations.
I removed all indexes that were tangled in with the affected columns.

Thanks for your thoughts. I think it is going to fly.

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