MySQL Lists: mysql: Re: SHOW foreign keys

List:	General Discussion	« Previous Message Next Message »
From:	Martijn Tonies	Date:	August 17 2004 10:24am
Subject:	Re: SHOW foreign keys
View as plain text

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

Thread
• SHOW foreign keys	Michael Seele	17 Aug
• Re: SHOW foreign keys	Martijn Tonies	17 Aug
• Re: SHOW foreign keys	Michael Seele	17 Aug
• Re: SHOW foreign keys	Martijn Tonies	17 Aug
• Multiple MySQL Versions on Same Linux Box	Lou Olsten	17 Aug
• Re: Multiple MySQL Versions on Same Linux Box	V. M. Brasseur	17 Aug