Last answered:

26 Nov 2023

Posted on:

11 Nov 2023

0

Key alone in line 7

what is KEY alone in line 7? It's was there even you dropped foreign key

3 answers ( 0 marked as helpful)
Instructor
Posted on:

13 Nov 2023

0

Hi Hamed!
Thanks for reaching out!


Could you please support your question with the entire code? This can help us assist you better. Thank you.


Looking forward to your answer.
Best,
Tsvetelin

Posted on:

14 Nov 2023

0

I mean line 7 in DDL, KEY 'customer_id'('customer_id')

when Forgein Key removed this line still exist

Instructor
Posted on:

26 Nov 2023

0

Hi Hamed!

Thanks for your reply.

This is Workbench's way to indicate customer_id is, at this moment, a foreign key. Yes, it sounds imperfect (since for primary key the indication we get is explicit), but that's how Workbench displays this indication to us in its current version, at least.

Hope this helps!
Kind regards,
Martin

Submit an answer