查看mysql主外键信息

SELECT  *FROMinformation_schema.key_column_usage tWHERE t.constraint_schema = '库名称'AND t.constraint_name = '外键名';

转载于:https://www.cnblogs.com/igoodful/p/8954091.html