Guillem Vicens wrote:

> This operation is not defined for system
> tables.unsuccessful metadata update.
> partner index segment no 2 has incompatible data type.
>
> I get this error when I try to create a foreign key in the last tables I
> created in my database. The database has 150 tables and the version
> is:Firebird-2.0.3.12981-1-Win32.
>
> Can anyvody please tell me what's wrong? Thanks in advance.

The data type in columns (FK and PK) is different. Perhaps it's the same
type like CHAR(10), but a different collation?

Without showing us the details (DDL for tables and FK) it's hard to tell.

--
Milan Babuskov
http://www.flamerobin.org