Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- MYSQL - Navicat - Foreign Keys
- Simon Bond
June 17, 2005, 7:07 am
rate this thread
Basically im using Navicat to work with my databases.
When making a foreign key, i am asked to enter the following details....
Foreign Key Name, Field Name, Reference Table, Foreign Field Names, On
Delete, On Update.
Now.. i don't understand why I have to specify a 'Foreign Key Name', as I
thought this would be the equivalant to the 'Field Name' (which is a field
containing my parent_id).
and obviously Foreign Field Name would be my ID from my other table that im
Soo why Foreign Key Name?
I apologise for my ignorance, but I have searched high and low for the
answer, and can't seem to get a grip around it.
Thanks to all in advance
Re: MYSQL - Navicat - Foreign Keys
How/Why is naming required. I thought defining the relationship between
Table1's ID and Table2's PARENT ID would be enough, but we have to give this
relationship its own name?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum