At 07:24 PM 8/30/2001 +0700, Andy Canfield wrote:

>I am trying to inactivate the index that Firebird automatically provides
>for foreign keys that reference other tables. I get an error saying that I
>cannot deactivate a primary key index. But it isn't a primary key index.

At one point, I thought that only the internal system triggers required
that those indexes exist. Unfortunately, reading a bit more of the code
shows that the existence of foreign key indexes is built-in and will require
considerable work to remove.


Regards,

Ann
www.ibphoenix.com
We have answers.