Support Center > Knowledgebase > phpMyAdmin > Known Limitations > With InnoDB tables, I lose foreign key relationships when I rename or alter a table.
With InnoDB tables, I lose foreign key relationships when I rename or alter a table.
This seems to be a InnoDB bug (fixed in MySQL 3.23.50?).
Also Read