""Nick Upson"" <uebridger@...> wrote in message
news:F71bA8pYCCCI5O8vEBc00014920@......

> is there anything I could do to the system tables so that the
> Foreign key (and it's index) would disappear following a backup/restore.
>
> I'm actually trying to delete the FK column from the table
> but, of course, it won't go while the FK depends upon it.

Try to use normal DML instead of DDL to delete the records from the system
tables, using isql:
Delete the record from rdb$relation_constraints
Delete the corresponding record from rdb$ref_constraints
Delete the index from rdb$indices
Delete the index's fields from rdb$index_segments
Commit

It would be good if you ensure that gfix doesn't detect corruption before
doing that.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing