What is Relation View and how can we enable it in phpMyAdmin?

kumkumsharma

Administrator
Staff member
If you want tp create foreign keys in database but you are not able to find the Relation View option then you have to make some changes in your phpMyAdmin. First you have to check the storage engine of your table and set it to InnoDB, its because only InnoDB allow Relation view from which we can make foreign keys.

You can check below steps to change storage engine:
  • Login to phpMyAdmin.
  • Now first go to particular table.
  • And then click on “Operations” tab which is under Table options. Now you will find drop down named Storage Engine.
  • Choose Innodb storage engine from drop down menu.
  • At last click on “Go” button.
 
Top