Hi Everyone,
I'm using PHPMyAdmin to set up the database for a website, and I am
trying to set up foreign keys between tables. I know that MySQL doesn't
enforce them, but I want them there as part of the schema anyway. I
tried executing the command to add the foreign key, it ran without any
error, but I don't see any indication that the foreign key exists as
part of the schema now. Is there a command either in PHPMyAdmin or MySQL
that will show me which fields are foreign keys, and where they point
to? I just want to make sure I set them up right.
Thanks,
Brian Rivet
