Subject Re: [firebird-support] Re: Fixing a varchar field
Author Ann W. Harrison
eddressel wrote:
>
> If I report this--are you going to take the feature away :-0

No, because it would break other things.
>
> I found out how to do this via IB Expert:
>
> update RDB$RELATION_FIELDS
> set RDB$FIELD_SOURCE = 'DM_STR30'
> where (RDB$FIELD_NAME = '<Field Name>')
> and (RDB$RELATION_NAME = '<TableName')

Direct system table updates are a classic way to screw up
your database. There are no sanity checks built into the
system tables - put in bad data and your database is garbage.
The ability to update the system tables directly seemed like
a good idea 25 years ago. We were wrong, but it did have
an interesting symmetry.

In short, don't do it, and if you do, don't expect sympathy.

Cheers,

Ann