List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 6 2004 1:05pm
Subject:Re: Where are the Foreign Keys?
View as plain text  
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 "comments" yourself anymore.
Besides, the "comments" field is waaay too short for a larger number
of FKs.

So, as far as I know, SHOW CREATE TABLE is the only way.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Thread
Where are the Foreign Keys?Ralf Müller6 Aug
  • Re: Where are the Foreign Keys?Martijn Tonies6 Aug
    • standard processing of metadataDebugasRu6 Aug
      • Re: standard processing of metadataJochem van Dieten6 Aug
RE: Where are the Foreign Keys?Naresh Sadhnani6 Aug
  • Re: Where are the Foreign Keys?Martijn Tonies6 Aug