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,
>though.

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.

Regards,

Ann
www.ibphoenix.com
We have answers.