Re: identifying foreign keys

2003-06-13 Thread Nils Valentin
SHOW CREATE TABLE tblname; Best regards Nils Valentin Tokyo/Japan 2003年 6月 14日 土曜日 05:22、Michael Conlen さんは書きました: > I'm working on a system that will allow me to perform operations on a > table using a web form, and I would like to know if a table has a > foreign key, however I don't seem to s

identifying foreign keys

2003-06-13 Thread Michael Conlen
I'm working on a system that will allow me to perform operations on a table using a web form, and I would like to know if a table has a foreign key, however I don't seem to see this information listed in any of the show commands output (or describe). Any idea how I could identify what colums ar