Posted by Erwin Moller on 01/25/07 13:42

Rik wrote:

> On Thu, 25 Jan 2007 11:15:01 +0100, Erwin Moller
> <since_humans_read_this_I_am_spammed_too_much@spamyourself.com> wrote:
>
>> Erwin Moller wrote:
>> 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.)
>
> Unfortunately, usually they can't.
>

Ah darn, there goes my good advise. ;-)

Luckily, if you define FK in the way you showed they DO show up with SHOW
CREATE TABLE tbl_XXX.
Still mySQL should really consider improving their FK support.
After all, that is what 'relational' means in a relational database. ;-)

Regards,
Erwin

• Next in forum: Re: mysqli connections and oop
• Prev in forum: Unable to access elements in SimpleXML
• Thread view: Re: [ot] listing foreign keys in mySQL on InnoDB

[Reply to this message]