--- In ib-support@y..., Sudheer Palaparambil <p_sudheers@y...> wrote:

> Hi,
>
> What does the following error means ? This happened
> when I tried to create a foreign key on table batch
> (both tables are empty now )
> ALTER TABLE batch ADD FOREIGN KEY (PRODUCT_ID)
> REFERENCES PRODUCT(ID);

Hi, Sudheer. We are colleagues on this misfortune, see my post
"RDB$INDEX_16 ...". What build are you using? I encounter this and
other problems on LI-T1.0.0.368 when change metadata being not the
single connected to database. About this concrete case - records in
RDB$FORMATS about one of this tables (in my case BATCH) or index
RDB$INDEX_16 UNIQUE INDEX ON RDB$FORMATS(RDB$RELATION_ID, RDB$FORMAT)
are corrupted. Since your tables are empty (I'm not so lucky), try to
drop them and create once more being the only one connected. Let me
know result, please, I'm not shure we can drop damaged table and I'm
interested in it too.

Best regards.