Posted by Erwin Moller on 01/25/07 10:15

Erwin Moller wrote:

<snip>
> I must be missing something completely in the docs. :-/
> How can I ask mysql which Foriegn Keys it has?
>

Hi,

In case somebody wants to see all Foreign Keys, I found place where they are
listed, be it in a userunfriendly way:

Just connect to:
- information_schema (it should be in any mySQL database)
- check the table TABLE_CONSTRAINTS

It lists all CONSTRAINTS. The column CONSTRAINT_TYPE will contain stuff like
'FOREIGN KEY' or 'PRIMARY KEY'.
Quite straightforward.
(My current knowledge of mysql is too meager to say if anybody in a shared
environment can read this table.)

Regards,
Erwin Moller

[Back to original message]