List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 6 2004 1:50pm
Subject:Re: Where are the Foreign Keys?
View as plain text  
>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 - 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