--- In firebird-support@yahoogroups.com, Raymond Kennington
<progsol@c...> wrote:

> ...

> >
> > ISC ERROR MESSAGE:
> > unsuccessful metadata update
> > object INDEX is in use
>
> Is the table open?

Not this table. There are many other tables open though.

> Is it possible that the system tables are already corrupted?

Nothing is impossible. I tried to remove the record I added to the
RDB$INDEX_SEGMENTS to start all over, and it won't let me do that either.

ISC ERROR MESSAGE:
action cancelled by trigger (1) to preserve data integrity
Cannot delete index segment used by an Integrity Constraint

Where can I find this constraint? Can it be removed? :>