mysql里找出一个表的主键被谁作为外键约束 博客分类: Database MySQL
程序员文章站
2024-02-22 16:41:58
...
SELECT ke.referenced_table_name parent, ke.table_name child, ke.REFERENCED_COLUMN_NAME parent_column, ke.column_name child_column, ke.constraint_name FROM information_schema.KEY_COLUMN_USAGE ke WHERE ke.referenced_table_name IS NOT NULL and ke.referenced_table_name = 'table_name' and ke.REFERENCED_COLUMN_NAME = 'id' and ke.REFERENCED_TABLE_SCHEMA = 'db_name' ORDER BY ke.referenced_table_name;
这样就可以找出'db_name'这个数据库下'table_name'这张表的id被哪些表作为外键约束
thx wwei!