Subject | RE: [ib-support] Firebird : How to have a foreign key without an automatic created related index |
---|---|
Author | Dmitry Yemanov |
Post date | 2001-08-29T14:27:07Z |
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
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