MySQL:如何找出哪些表引用了特定表?

本文介绍了MySQL:如何找出哪些表引用了特定表?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想删除一个表，但它被一个或多个其他表引用.如何在不必逐个查看数据库中的每个表的情况下找出哪些表正在引用该表?

I want to drop a table but it is referenced by one or more other tables. How can I find out which tables are referencing this table without having to look at each of the tables in the database one by one?

推荐答案

SELECT TABLE_NAME FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = 'your_schema_name' AND REFERENCED_TABLE_NAME = 'your_table_name';

这行得通.