查看mysql主外键信息

SELECT  *
FROM
information_schema.key_column_usage t
WHERE
t.constraint_schema = '库名称'
AND t.constraint_name = '外键名';

posted @ 2018-04-26 17:48  igoodful  阅读(3144)  评论(0编辑  收藏  举报