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 see this information listed in any > of the show commands output (or describe). Any idea how I could identify > what colums are foreign keys and what they reference without having to > tell the code? I use 'describe table' to get most of the information out > I need. > > Oh yes, MySQL 4.0.12 on FreeBSD using INNODB tables. > > Thanks much. > > -- > Michael Conlen -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]