Tom Roos wrote:
hi
how does 1 know if a foreign key is defined? describe tablename and show index from tablename dont sufice
tks
SHOW CREATE TABLE tablename;
or
SHOW TABLE STATUS LIKE 'tablename';
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]