Posted by Rik on 01/25/07 11:27

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.

--
Rik Wasmus
* I'm testing several new newsreaders at the moment. Please excuse
possible errors and weird content. *

• Next in forum: Re: DB -> Flat file, did I waste my time?
• Prev in forum: Re: how to avoid eval()
• Thread view: Re: [ot] listing foreign keys in mySQL on InnoDB

[Reply to this message]