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

2022-01-20 00:00:00 foreign-keys 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';

这行得通.

相关文章