show constraints

am 10.11.2006 23:50:10 von John Smit

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

Re: show constraints

am 12.11.2006 13:31:48 von John Smit

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

Rob

"John Smit" wrote in message
news:c2988$45550222$3ea34df4$27917@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

Re: show constraints

am 14.11.2006 07:51:23 von lorento

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