Look for a substring beginning with 'FOREIGN KEY' in the result of 'SHOW CREATE TABLE tblname'.
PB ----- Original Message ----- From: Tom Roos To: [EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:05 AM Subject: foreign keys...... hi how does 1 know if a foreign key is defined? describe tablename and show index from tablename dont sufice tks Disclaimer http://www.shoprite.co.za/disclaimer.html
