假设我们有一个包含多个表的数据库“business”。如果您只想显示外键约束，请使用以下查询 -
mysql> select * −> from information_schema.referential_constraints −> where constraint_schema = 'business';
以下是仅显示外键约束的输出 -
+--------------------+-------------------+--------------------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------+-------------------+-----------------------+| constraint_catalog | constraint_schema | constraint_name | unique_constraint_catalog | unique_constraint_schema | unique_constraint_name | match_option | update_rule | delete_rule | table_name | referenced_table_name |+--------------------+-------------------+--------------------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------+-------------------+-----------------------+| def | business | constchild | def | business | primary | none | no action | no action | childdemo | parentdemo || def | business | constfk | def | business | primary | none | no action | no action | tblf | tblp || def | business | constfkpk | def | business | primary | none | no action | no action | foreigntable | primarytable1 || def | business | fkconst | def | business | primary | none | no action | no action | foreigntabledemo | primarytabledemo || def | business | primarytable1demo_ibfk_1 | def | business | primary | none | no action | no action | primarytable1demo| foreigntable1 || def | business | studcollegeconst | def | business | primary | none | no action | no action | studentenrollment| college |+--------------------+-------------------+--------------------------+---------------------------+--------------------------+------------------------+--------------+-------------+-------------+-------------------+-----------------------+6 rows in set (0.07 sec)
以上就是获取mysql中的外键约束列表的详细内容。