mysql查看数据库所有外键列表指令

---

在无工具的情况下，想一下查看一个库中的所有外键，是可以通过如下指令实现的：

---

select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where table_schema='$databasename' and referenced_table_name is not null;

其中'$databasename' 要替换成您要查询的那个数据库的名称。  

---

例如：

select concat(table_name, '.', column_name) as 'foreign key', concat(referenced_table_name, '.', referenced_column_name) as 'references' from information_schema.key_column_usage where table_schema='thunderemm' and referenced_table_name is not null;