
20 Jul
2009
20 Jul
'09
2:01 p.m.
Hi all, I tried to make a column in the table 'student_course' foreign key using the query "ALTER TABLE student_course ADD FOREIGN KEY (Course_Id) REFERENCES course(Id)"; I also got the success message that the query has been executed successfully. But when I tried the query "SHOW TABLE STATUS FROM db_name LIKE 'student_course' ;" to get foreign key information from the comments, the comments were empty. I also used the function in libraries/relation.lib.php PMA_getForeigners() but the result is empty. I think the foreign key is not being created properly so tell me the correct syntax for creating the foreign key. I need help ASAP. Regard, Zahra.