Key alone in line 7
what is KEY alone in line 7? It's was there even you dropped foreign key
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.
I mean line 7 in DDL, KEY 'customer_id'('customer_id')
when Forgein Key removed this line still exist
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!