Hi,

I have to enlarge a VARCHAR column from 20 to 50 chars.
As this column is referenced by many triggers and SPs, I cannot
just delete and recreate it by using a helper field.

I could perhaps do it like that:

update RDB$FIELDS set
RDB$FIELD_LENGTH = 50,
RDB$CHARACTER_LENGTH = 50
where RDB$FIELD_NAME = 'RDB$353'

Many direct modifications of system tables are dangerous, so I would
rather avoid this. Is there another way? Or can somebody confirm that
the above query is not dangerous?

Thanks in advance,


Christian