Error when creating Foreign Key

[molino]

Hello,
when creating a foreign key per GUI in dbForge I was getting the 150 error message. After entering the same FK manually as SQL command it was executed without issues.
I made a screenshot of the settings that failed and I compared them to the final values and they were identic.

This was the executed comand:

Code: Select all

ALTER TABLE psv.einkaufsposition
ADD CONSTRAINT FK_ek_pos_ReferenzAuftragsID
FOREIGN KEY (ReferenzAuftragsID) REFERENCES geschaeftsvorgang(Geschaeftsvorgang_ID) ON DELETE NO ACTION;

Best Regards,
Raul

[alexa]

Could you please provide us a screenshot displaying the whole window of dbForge along with the error?

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .