Subject RE: [firebird-support] Re-post: Changing a domain name
Author George P Boutwell
> -----Original Message-----
> Is secure create a new domain and to do something as:
>
> UPDATE RDB$RELATION_FIELDS
> SET RDB$FIELD_SOURCE='NEW_DOMAIN_NAME'
> WHERE (RDB$FIELD_NAME='FIELD_NAME' AND
> (RDB$RELATION_NAME='TABLE_NAME')

It's highly 'frowned' upon to manipulate the System Tables (RDB$?
tables). I would say you are inviting trouble if you do it.

Having said that, you can create an test case DB, or make a copy of
your existing DB, and make the change on it in an lab condition and see
if it works. If it does then you can probably do it.

George

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003