Hello all,

I know of the SHOW FIELDS... and SHOW KEYS... statements. I see there is no
SHOW CONSTRAINTS statement.
Is there an other way to find out which foreign keys a table has
implemented?

Thanks in advance Rob

I am using PHP 5 and MySQL 5.1 on a windows XP with Apache 2

Rob

"John Smit" <noreply [at] nodomain.xxx> wrote in message
news:c2988$45550222$3ea34df4$27917 [at] news.chello.nl...
> Hello all,
>
> I know of the SHOW FIELDS... and SHOW KEYS... statements. I see there is
> no SHOW CONSTRAINTS statement.
> Is there an other way to find out which foreign keys a table has
> implemented?
>
> Thanks in advance Rob

Use command:

SHOW CREATE TABLE table_name

Note, foreign key available only in innodb. If you use myisam there is
no foreign key.

--
http://www.mastervb.net
http://www.theukmap.com

John Smit wrote:
> Hello all,
>
> I know of the SHOW FIELDS... and SHOW KEYS... statements. I see there is no
> SHOW CONSTRAINTS statement.
> Is there an other way to find out which foreign keys a table has
> implemented?
>
> Thanks in advance Rob