mysql查询出有外键的表

登录后复制

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'
AND TABLE_SCHEMA = 'database';

• 1.
• 2.
• 3.
• 4.

原创作者: u_16405566 转载于: https://blog.51cto.com/u_16405566/11499972