Subject RE: [ib-support] Foreign Key -- Alter Table fails -- could not find UNIQUE INDEX with specified columns
Author Martijn Tonies
> David,
> This is reminiscent of an old thread that circulated around the old
> list more than once, wrt to IB 5.x. AFAIK, the error message is
> misleading, insofar as it implies that you can form a foreign key that

> refers to a unique index. I believe in FB/IB, this is not the whole
> story. A foreign key has to refer the primary key of the reference
> (which, by definition, has a unique index...) It should be telling
> "could not find PRIMARY KEY with specified columns".

or UNIQUE constraint... for that matter...

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird