Home > Archive > PHP SQL > November 2006 > show constraints
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| John Smit 2006-11-10, 6:57 pm |
| 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
| |
| John Smit 2006-11-12, 7:57 am |
|
I am using PHP 5 and MySQL 5.1 on a Windows XP with apache 2
Rob
"John Smit" <noreply@nodomain.xxx> 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
| |
| lorento 2006-11-14, 3:59 am |
| 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
|
|
|
|
|