MySQL Lists: mysql: Re: Where are the Foreign Keys?

List:	General Discussion	« Previous Message Next 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üller	6 Aug
• Re: Where are the Foreign Keys?	Martijn Tonies	6 Aug
• standard processing of metadata	DebugasRu	6 Aug
• Re: standard processing of metadata	Jochem van Dieten	6 Aug
• RE: Where are the Foreign Keys?	Naresh Sadhnani	6 Aug
• Re: Where are the Foreign Keys?	Martijn Tonies	6 Aug