Creating Foreign Keys - MySQL

  • Nobody/Anonymous

    I upgraded to the latest version because I saw examples on the home page that indicated adminer could create foreign keys - but I'm darned if I can see how/where to do it. The foreign key option shown in the images on the web site do not appear when I create tables etc.  What am I missing?

  • Jakub Vrána

    Jakub Vrána - 2011-05-13

    Foreign keys in MySQL are supported only with InnoDB table type, not with MyISAM.

  • Nobody/Anonymous

    Actually I'm not using either - I'm using IBM DB2 storage engine but I suspect that the issue is the same. Thanks

  • Jakub Vrána

    Jakub Vrána - 2011-05-17

    IBMDB2I supports foreign keys too so I've added it to the Git version of Adminer.

  • Nobody/Anonymous

    Thanks for that - I'll give it a try but …

    Excuse my ignorance but I barely know what Git is and can find no link to that version on this site. 


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks