From: Martijn Tonies
Date: August 17 2004 10:24am
Subject: Re: SHOW foreign keys
List-Archive: http://lists.mysql.com/mysql/171071
Message-Id: <02cb01c48444$68ad0ab0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> how can i get all the foreign keys from a database? i used SHOW INNODB
> STATUS; but i get an unknown error!

You can only get them on a per-table basis with a
SHOW CREATE TABLE <tablename> statement.

With regards,

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