MySQL Forums
Forum List  »  Newbie

Error 3734
Posted by: LEO DEL CIELLO
Date: March 12, 2024 12:51AM

I am a beginner in MySql though I have some experience with dbs (Sql Server).
I am trying to forward - engineer a diagram which includes 2 tables and a relation between them .
I have generated the relation using the environment tool, specifying the PKs of both tables as usual.
I keep having a 3734 error on a column which is part of the PK of one of these tables.
The error states :
"ERROR: Error 3734: Failed to add the foreign key constraint. Missing column 'IdArticolo' for constraint 'fk_Azienda_has_Articolo_Articolo1' in the referenced table 'articolo'"

Where 'Articolo' and 'Azienda' are the two tables , and 'IdArticolo' is one of the columns which are part of Articolo's PK. The column does indeed exist, and it is written exactly as the error states (I mean no mismatch in capitalizing), but for some strange reason it cannot find it. What could be the cause ?

Options: ReplyQuote


Subject
Written By
Posted
Error 3734
March 12, 2024 12:51AM
March 12, 2024 03:00AM
March 12, 2024 03:35AM
March 13, 2024 01:14AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.