I need to change the scale of numeric domain from (15,4) to (15,8).

I cannot use the ALTER command, since FB doesn't allow such change.
BUT I'm 100% sure that all the existing data would perfectly fit in
(15,8) so, the question is: In this case, is it safe to make the
change direct in the system table?

update RDB$FIELDS set
RDB$FIELD_SCALE = -8
where RDB$FIELD_NAME = 'RDB$nnnn';

[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br