MySQL:如何找出哪些表引用了特定表? [英] MySQL: How do I find out which tables reference a specific table?

问题描述

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

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';

这行得通.

这篇关于MySQL:如何找出哪些表引用了特定表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！