Hi Ralf,
as far as i know, there is only 1 way to extract the foreign key relations
from a table: show create table tablename.
Are there any others?
The comments column in SHOW TABLE STATUS is supposed
to list the FKs as well. A rather silly way of doing things, IMO,
cause you can't use the
You could also try
SHOW KEYS FROM dbname.tablename
Should work.
Naresh
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 14:06
To: [EMAIL PROTECTED]
Subject: Re: Where are the Foreign Keys?
Hi Ralf,
as far as i know, there is only 1 way
From: Naresh Sadhnani
You could also try
SHOW KEYS FROM dbname.tablename
Should work.
According to the documentation, this is an alternative
for SHOW INDEX FROM tablename
A quick try gave me no results for FKs, only PKs
and indices.
With regards,
Martijn Tonies
Database Workbench -