Hello.
Have you tried 'SHOW CREATE TABLE'? See:
http://dev.mysql.com/doc/mysql/en/show-create-table.html
>HI everybody
>
>I'm tryng to find a way to know if a field is a foreign key, by example
>if I run this
>
>describe ;
>
>in the "Key" colum I got "PRI" for the primary key f
IF you are on 5.0.x you can use INFORMATION_SCHEMA
21.1.13. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
http://dev.mysql.com/doc/mysql/en/key-column-usage-table.html
-Original Message-
From: Operator [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 05, 2005 3:02 PM
To: mysq
