search

Home  >  Q&A  >  body text

MYSQL I want to know how to query the name of the foreign key

I use show create table myforeign; statement query but I can’t see the name of the foreign key. The mysql I use is the one in the PHP toolbox

AdolphAdolph2346 days ago1066

reply all(2)I'll reply

  • 无忌哥哥

    无忌哥哥2018-06-22 10:17:22

    select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE试试

    reply
    1
  • Adolph

    OK solved. Thank you.

    Adolph · 2018-06-22 11:07:40
  • Cancelreply