>Udo wrote:
>> Hi,
>> When I try to create a constraint REFERENCES of FK with this
>> command:
>>   ALTER TABLE TESTE
>>      ADD CONSTRAINT TESTE_FK
>>          FOREIGN KEY (LOC_ID)
>>          REFERENCES LOCALIDADE (LOC_ID);

>>   Since the index TESTE_FK already exists in the column LOC_ID
>>   But occurs the error message:

>>   Unsuccessful metadata update
>>   STORE RDB$REF_CONSTRAINTS failed
>>   action cancelled by trigger (1) to preserve data integrity
>>   Name of Referential Constraint not defined in constraints table
>>   Statement: ALTER TABLE TESTE
>>                 ADD CONSTRAINT TESTE_FK
>>                 FOREIGN KEY (LOC_ID)
>>                 REFERENCES LOCALIDADE (LOC_ID)

>>   What is the problem?
>>   Thanks
>>   Udo

>--
>Thomas Miller
>Delphi Client/Server Certified Developer
>BSS Accounting & Distribution Software
>BSS Enterprise Accounting FrameWork

>http://www.bss-software.com

> Thomas Miller <tmil...@bss-software.com> wrote:

>>Which database and version?

>>Udo wrote:

>>>Hi,
>>>When I try to create a constraint REFERENCES of FK with this
>>>command:
>>>  ALTER TABLE TESTE
>>>     ADD CONSTRAINT TESTE_FK
>>>         FOREIGN KEY (LOC_ID)
>>>         REFERENCES LOCALIDADE (LOC_ID);

>>>  Since the index TESTE_FK already exists in the column LOC_ID
>>>  But occurs the error message:

>>>  Unsuccessful metadata update
>>>  STORE RDB$REF_CONSTRAINTS failed
>>>  action cancelled by trigger (1) to preserve data integrity
>>>  Name of Referential Constraint not defined in constraints table
>>>  Statement: ALTER TABLE TESTE
>>>                ADD CONSTRAINT TESTE_FK
>>>                FOREIGN KEY (LOC_ID)
>>>                REFERENCES LOCALIDADE (LOC_ID)

>>>  What is the problem?
>>>  Thanks
>>>  Udo

>>--
>>Thomas Miller
>>Delphi Client/Server Certified Developer
>>BSS Accounting & Distribution Software
>>BSS Enterprise Accounting FrameWork

>>http://www.bss-software.com