Subject RE: [ib-support] Firebird : How to have a foreign key without an automatic created related index
Author Helen Borrie
At 06:27 PM 29-08-01 +0400, you wrote:
>I'm confirming it with my Win32 1.0.0.338 beta 2 build:
>
>alter table "Activities" add constraint fk_activities foreign key
>("Company") references "Agents" ("Id");
>commit;
>
>then
>
>alter index rdb$foreign64 inactive;
>
>=>
>
>This operation is not defined for system tables.
>unsuccessful metadata update.
>MODIFY RDB$INDICESS failed.
>action cancelled by trigger (3) to preserve data integrity.
>Cannot deactivate primary index.
>
>Dmitry


Thanks, Dmitry!

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________