Last answered:

22 May 2024

Posted on:

26 Jun 2023

1

Resolved: SQL: Foreign Key Constraint Part II

I also do not see the foreign key under the foreign key tab.  I do not get any error messages.  If I look at the INDEXES tab, I can see the constraint.    Will appreciate any assistance.  Thank you!

5 answers ( 2 marked as helpful)
Posted on:

26 Jun 2023

0

SCHEMA also shows that the contraint was registered.

Instructor
Posted on:

03 Jul 2023

3

Hi Anita!
Thanks for reaching out.


This is a well-known bug from the Workbench. It will not affect the smooth taking of the courses. Enjoy!


Hope this helps.
Best,
Tsvetelin

Posted on:

13 Jul 2023

1

Same issue. I also do not see the foreign key under the foreign key tab.

Posted on:

08 Nov 2023

1

@Tvetelin Tsonkov, 
That well-known bug for workbench would be a good thing to mention in the notes in the assignments.  I spent a while trying to figure out why this was happening and redoing my work, and then looking in all the other places trying to figure out why it wasn't registering there.  And, since this has been an issue for a while I think it would be easy enough to edit the text of the course to help students out.  

Instructor
Posted on:

22 May 2024

0

Hi Asim and Sarah!

Thanks for reaching out and for your feedback!

I have marked your comments and will consider adding a note on the relevant places the next time we are updating the course.

Hope this helps.
Kind regards,
Martin

Submit an answer