Subject RE: [ib-support] Direct modification to system tables to...
Author Ann W. Harrison
At 09:07 AM 7/10/2001 +0200, Kaputnik wrote:

<wrt: changing the field source from one domain to another>

>Don't know how indizes on the affected columns could be affected,

As long as the change is done within a major type, there will
be on effect on indexes. Major types are date, number, and
string. If you change a date or a number to a string (or vice
versa), you must rebuild indexes.

Changing the system tables directly does not cause constraints
to be checked. Nor does it cause the system to check that all
stored data fits in the new domain. If you ever want to scramble
a database, just cut all the string lengths in half.


We have answers.