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 tablename;
in the Key colum I got PRI for the primary key
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 tablename;
in the Key colum I got PRI for the primary key field, somebody know a way
to get the foreign keys ?
Regards
Daniel
To: mysql@lists.mysql.com
Subject: how to list foreign keys
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 tablename;
in the Key colum I got PRI for the primary key field, somebody know
a way to get the foreign keys